ALL vs ALLSelected in Power BI and DAX
Вставка
- Опубліковано 21 сер 2024
- These two functions in DAX are often used instead of each other; ALL and ALLSELECTED. Their behavior can be similar in some contexts, but it can also be different in other contexts. In this article and video, I'll explain the difference between these two functions and when to use each in DAX for Power BI, Analysis Services, or Power Pivot.
Learn more by reading my blog article here:
radacad.com/po...
Probably the best UA-cam explanation on ALL v ALL SELECTED
Right? He explained it so perfectly, it made me check out his other videos.
Thanks. Finally someone explained it in a simple and clear way.
This is how explanation videos should be like 👏🏻 👏🏻 👏🏻
Thanks. I am glad you liked it.
OMG. Finally, a simple explanation I could understand. I'm from science background trying to get into Data Analytics and your's is the first video that could explain all these three functions for me in an understandable way. Thank you.
Thanks. I am glad it was helpful.
Thanks Reza!! I'm superfan of your videos, this one very necessary to understand abstract concepts in a simple way 👍
Thanks for your kind words Antonio!
Wow good, explained video. It has cleared all my doubts.
Thank you for your making this video.
Nice and simple explanation. Thanks a lot.
Very Clear Demo !! Thank you very much for Sharing.... Appreciated you effort of Making ... Keep sharing more video. I learned new things today :)
Thanks 👊👊
Mu mornong rputine now has become to watch you videos while traveling to office
Hi Reza, I am facing a challenge with Power BI and desperately need the help of someone who really knows Power BI. This is my problem:
I work in the insurance industry and the products we sell are policies. Several insurers can participate in a single policy and therefore the price for a policy is the sum of the individual prices charged by each insurer that takes up that policy. If I look at the price of a policy when I consider all insurers, it would be something around a million ($1,000,000), however, if I filter my data for just one participating insurer, then the price is much smaller, that is, say 100K ($100,000).
I would like to create a chart that on the X-axis display premium buckets and on the Y-axis displays bars counting the number of policies which premium falls in each of those buckets. The thing is, sometimes I will not not filter my data for any specific insurer and as a result the premium for each policy is the total premium for all participating insurers combined. this means that premium for each policy is high, often above $1m. However, there will be instances when I want to filter the data for just one single insurer, and therefore, the premium for each policy is limited to the premium charged solely by the insurer being considered. In this case, the premium for each policy would be around $100K. I would like the premium buckets in the X axis to be adjust to reflect the average policy premium once a selection is made for the number of insurers to be considered.
I have already checked this UA-cam inside and out but did not find a solution. I watched your video for age group but I could not implement that solution on what I need to achieve.
Please Reza, help me!!!