Building a Virtual Relationship in Power BI Basics of TREATAS DAX Function

Подписаться 48 тыс.

Просмотров 10 тыс.

50% 1

TreatAs is an interesting function with multiple use cases in Power BI. I thought it is good to explain it in a set of videos, the first one here is about what the TreatAs function is and how it can help to build filters and a virtual relationship between two tables. Let's see how you can use this function.
Download the Power BI file and get the links to study more here in my blog article:
radacad.com/bu...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: learn.radacad.com
Become an academy member: learn.radacad....
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / 6393399
-- radacad.com
********

Наука

Опубликовано:

1 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 21

@vicenteantoniomagallanesju5289 Год назад

Hello i have a questions , treatas admit a volumn with origin in function addcolumns??

@ssma1368 4 года назад

Interesting and helpful! I’m waiting for next video about multiple rows.

@debojitpaul5779 Год назад

explained properly

@Darknesslc3 3 года назад

thank you for explaining in a very beginner friendly manner with many examples, other utube videos couldnt explain it so well

@supersayan9888 3 года назад

Really well explained. I'm just curious why you would use treatas rather than creating a relationship between the two tables. Wouldn't treatas create performance problems? if you have a large data set. so my question is: When would treatas be of benift? And when would treatas be of disadvantage?

@RADACAD 3 года назад

I wouldn't use TreatAs as the replacement of the relationship. I would still recommend to use the relationships whenever you can. However, there can be scenarios that depends on the situation, you might want to create a relationship at a different granularity than what exists in the model. using TreatAS with combination of functions such as Values you can do that, but in the actual relationship diagram that might mean a many-to-many relationship which is not ideal.

@totvabe1 4 года назад

What if you use TREATAS when the relationship exists?

@RADACAD 4 года назад

It depends on how you use the treatas. If you use it just for a simple filtering like what I did in this video, then the result would be the same with or without the relationship.

@ArifulIslam-gs6uy 3 года назад

Nice Explanation...

@tlee7028 2 года назад

Awaesome tutirial !

@karshadi9554 4 года назад

Very good! Thanks dear Mr. Rad.

@grant4458 Год назад

Great explanation in 2023. Thank you

@RADACAD Год назад

Glad it was helpful!

@jazzista1967 4 года назад

Forgot to ask you , in excel 365 I don't have the treatas function. What other function can I use that simulate this behavior?

@RADACAD 4 года назад

Because the main function of TREATAS is filtering, you can use FILTER instead in most of the occasions.

@jazzista1967 4 года назад

Got it.

@jazzista1967 4 года назад

Reza : Great posting! 2 questions. What are the disadvantages of not having ANY relationship in the data model? Also, what are the orders of the columns you are trying to relate in treatas : do you start with the many side or with the one side. Great examples. Thanks

@zibroyd 4 года назад

here is you can see another functions and explanations how to use them, if you dont have treat as, and also the difference in performance www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/

@RADACAD 4 года назад

Definitely not recommended to not have relationships in the data model. Using the relationships you can easily understand what table filters what. without it, it will cause ambiguity. On the other hand, if you do not have relationships, then for every value, you need to write a measure with filtering (either with TREATAS or other DAX functions), vs, if you have relationships, many of values gets filtered themselves. TREATAS is not a remedy for relationship problems, it is another way of filtering.

@jazzista1967 4 года назад

@@zibroyd Thanks for the link. I will definably will take a look!

@jazzista1967 4 года назад

Thanks Reza.