How to Use the ALL DAX Function in Power BI

  Рет қаралды 18,360

Nestor Adrianzen

Nestor Adrianzen

Күн бұрын

Пікірлер: 40
@johnfunet
@johnfunet 2 жыл бұрын
I love the way you explain things, always very clear and with dedication. Keep posting these very informative videos, whenever I have a problem I always search for Nestor, and “boom” I always get a solution. Regards John Copperstone, Malta
@NestorAdrianzen
@NestorAdrianzen 2 жыл бұрын
Thank you very much! 💥 Boom!
@varshaiyer4764
@varshaiyer4764 2 жыл бұрын
Very nicely explained .
@NestorAdrianzen
@NestorAdrianzen 2 жыл бұрын
Glad to hear that!
@michafabich9213
@michafabich9213 2 жыл бұрын
Perfect explanation, learnt a lot
@NestorAdrianzen
@NestorAdrianzen 2 жыл бұрын
Glad to hear that!
@mr.prasadyadav
@mr.prasadyadav 3 жыл бұрын
Thanks alot Master of Power BI , if it's possible Please keep teach all Dax Functions at high it's very useful to us .
@NestorAdrianzen
@NestorAdrianzen 3 жыл бұрын
Thanks for your support, Mr. Prasad! I will try my best!
@mansijswarnkar2183
@mansijswarnkar2183 2 жыл бұрын
Amazing you are ! Thank you
@NestorAdrianzen
@NestorAdrianzen 2 жыл бұрын
Wow, Thanks for your feedback!
@radhaglasti
@radhaglasti 4 жыл бұрын
Really simplely explained.awesome!! Thanks...
@NestorAdrianzen
@NestorAdrianzen 4 жыл бұрын
Glad it was helpful!
@mohdmuzammil3059
@mohdmuzammil3059 4 жыл бұрын
Explained beautifully👍, Allexpect expecting in next video
@NestorAdrianzen
@NestorAdrianzen 4 жыл бұрын
Glad you found it helpful!
@raulparra60
@raulparra60 4 жыл бұрын
Estupendo video. muy claro como explica. saludos desde Bogota
@NestorAdrianzen
@NestorAdrianzen 4 жыл бұрын
Excelente Raúl. Saludos a todos en la hermana república de Colombia.
@vincenzo4259
@vincenzo4259 3 жыл бұрын
Thanks
@NestorAdrianzen
@NestorAdrianzen 3 жыл бұрын
No problem. Keep it up, Vincenzo!
@ShrutiIyer88
@ShrutiIyer88 4 жыл бұрын
Thank you so much! I had a remark about case 4.1 . What if I used the Query Editor, duplicated the claims table and filtered the Category and Products Claimed table to just the 3 categories and 5 products claimed and saved it as a new table, wouldn't it perform the same function as ALL?
@NestorAdrianzen
@NestorAdrianzen 4 жыл бұрын
Shruti, Thanks for your question. Yes, we can also use your approach. For this particular case, I am using FILTER to show that it is a table function. If we have to pick one method or another, we might want to check the performance by using DAX Studio. Great approach as well!
@michafabich9213
@michafabich9213 2 жыл бұрын
Have a qq: what was the reason using All in last example ? As far as I noticed we do not have any filter context in the visual to be overwritten by ALL. Can't we just go with coffee makers without using all there?
@NestorAdrianzen
@NestorAdrianzen 2 жыл бұрын
Hey Michal, Thanks for stopping by. Yeah, if we don't have any filter affecting a column or table, the result would be the same. However, I'd encourage everyone to use the ALL function for more complex calculations.
@mansijswarnkar2183
@mansijswarnkar2183 2 жыл бұрын
To check the claim cost for Coffee maker, we could simply put the Claim cost into the colum ! :)
@NestorAdrianzen
@NestorAdrianzen 2 жыл бұрын
Yes, that also work. However, measures will give you more flexibility.
@raghunadhamara6243
@raghunadhamara6243 3 жыл бұрын
Can please make a video of basic issues we face in live please
@NestorAdrianzen
@NestorAdrianzen 3 жыл бұрын
Thanks for you question, Raghu. Do you have a specific topic in mind?
@raghunadhamara6243
@raghunadhamara6243 3 жыл бұрын
@@NestorAdrianzen sry but I don't have any specific topic
@zeroskiing
@zeroskiing 3 жыл бұрын
Keep making videos.....
@NestorAdrianzen
@NestorAdrianzen 3 жыл бұрын
Thank you, I will.
@ShrutiIyer88
@ShrutiIyer88 4 жыл бұрын
I'm sorry to disturb you again! I have a question about SUMX. Was wondering if you could use SUM instead of SUMX at 10:25
@NestorAdrianzen
@NestorAdrianzen 4 жыл бұрын
Hey, Shruti! Yes, you are correct!
@talehshafaggatov197
@talehshafaggatov197 3 жыл бұрын
@@NestorAdrianzen at 10.25 when you use SUMX( table, expression) you choose " collected premium" in expression part of SUMX. could you please advise if you created "collected premium" measure in advance?
@spoiltbrat55
@spoiltbrat55 3 жыл бұрын
so you used the formula Total Premium= sumx(All(claims),claims[collected premium])..here i have two questions..what happens if we dont use All in the above formula..secondly, what happens is i use sum in place of sumx..
@NestorAdrianzen
@NestorAdrianzen 3 жыл бұрын
Prasad Nori, Thanks for stopping by. Good questions. 1. The purpose of using ALL was to remove any filter in the claims table. If we don't use it and there are filters applied to that table, we might expect different results. 2. The SUMX function gives us more flexibility to apply additional calculations. For example, I could have done: Premium = SUMX (All (claims,), claims[collected premium * 2] In this tutorial, since we are only aggregating values from the Collected Premium column, we could have used SUM as well.
@raghunadhamara6243
@raghunadhamara6243 3 жыл бұрын
Hi experts , I just publish a report for 10 users and except 1 all are able to view. There is no role change or permission changes . How can i trouble shoot it . Can anyone please help me with it. Can you suggest the basic issues we face in work
@NestorAdrianzen
@NestorAdrianzen 3 жыл бұрын
RAGHU NADH AMARA. Thanks for your question. Do you know if a dynamic Row-Level Security has been implemented? Have you shared your report with all of them? if so, perhaps, you will need to provide them access to the Workspace [where the report is published ] as well. I hope it helps!
@raghunadhamara6243
@raghunadhamara6243 3 жыл бұрын
@@NestorAdrianzenthanks for the responce yes, I check all the rls and and shared it but still it happening.
@prabhatdass6184
@prabhatdass6184 4 жыл бұрын
Last measure even if we do not use all function would have given the same result.
@NestorAdrianzen
@NestorAdrianzen 4 жыл бұрын
Prabhat, You are correct! We could have written the last measure as follow as well: Claim Cost Coffee Maker: CALCULATE ( SUM(Claims[Claim Cost]), Claims[Product claimed = "Coffee Maker" ) I wanted to include ALL in this measure just to give everyone awareness about the use of ALL as part of the CALCULATE function.
@prabhatdass6184
@prabhatdass6184 4 жыл бұрын
@@NestorAdrianzen got it thanks for the response.
MEASURES vs CALCULATED COLUMNS in DAX
21:19
Nestor Adrianzen
Рет қаралды 10 М.
How to Use VARIABLES in Dax Formulas in Power BI
17:13
Nestor Adrianzen
Рет қаралды 24 М.
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН
How to treat Acne💉
00:31
ISSEI / いっせい
Рет қаралды 108 МЛН
Сестра обхитрила!
00:17
Victoria Portfolio
Рет қаралды 958 М.
TAME the the beast that is DAX in Power BI (aka how to learn DAX)
14:06
Making DAX Easy
20:01
How to Power BI
Рет қаралды 224 М.
How to Use the Filter DAX Function in Power BI [The Basics]
22:27
Nestor Adrianzen
Рет қаралды 35 М.
MASTERING Bar Charts in Power BI | No more Cut Labels
15:34
How to Power BI
Рет қаралды 144 М.
All Function in Power BI DAX
10:01
Dhruvin Shah
Рет қаралды 7 М.
How to Use the CALCULATE Function in Power BI
19:31
Nestor Adrianzen
Рет қаралды 59 М.
The Excel Tool That Does What PivotTables Can’t (File Included)
13:59
MyOnlineTrainingHub
Рет қаралды 288 М.
Handling MULTIPLE fact tables in Power BI
9:02
Guy in a Cube
Рет қаралды 329 М.
📊 How to use Power BI DAX - Tutorial
37:28
Kevin Stratvert
Рет қаралды 1,2 МЛН
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН