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
@NestorAdrianzen2 жыл бұрын
Thank you very much! 💥 Boom!
@varshaiyer47642 жыл бұрын
Very nicely explained .
@NestorAdrianzen2 жыл бұрын
Glad to hear that!
@michafabich92132 жыл бұрын
Perfect explanation, learnt a lot
@NestorAdrianzen2 жыл бұрын
Glad to hear that!
@mr.prasadyadav3 жыл бұрын
Thanks alot Master of Power BI , if it's possible Please keep teach all Dax Functions at high it's very useful to us .
@NestorAdrianzen3 жыл бұрын
Thanks for your support, Mr. Prasad! I will try my best!
@mansijswarnkar21832 жыл бұрын
Amazing you are ! Thank you
@NestorAdrianzen2 жыл бұрын
Wow, Thanks for your feedback!
@radhaglasti4 жыл бұрын
Really simplely explained.awesome!! Thanks...
@NestorAdrianzen4 жыл бұрын
Glad it was helpful!
@mohdmuzammil30594 жыл бұрын
Explained beautifully👍, Allexpect expecting in next video
@NestorAdrianzen4 жыл бұрын
Glad you found it helpful!
@raulparra604 жыл бұрын
Estupendo video. muy claro como explica. saludos desde Bogota
@NestorAdrianzen4 жыл бұрын
Excelente Raúl. Saludos a todos en la hermana república de Colombia.
@vincenzo42593 жыл бұрын
Thanks
@NestorAdrianzen3 жыл бұрын
No problem. Keep it up, Vincenzo!
@ShrutiIyer884 жыл бұрын
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?
@NestorAdrianzen4 жыл бұрын
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!
@michafabich92132 жыл бұрын
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?
@NestorAdrianzen2 жыл бұрын
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.
@mansijswarnkar21832 жыл бұрын
To check the claim cost for Coffee maker, we could simply put the Claim cost into the colum ! :)
@NestorAdrianzen2 жыл бұрын
Yes, that also work. However, measures will give you more flexibility.
@raghunadhamara62433 жыл бұрын
Can please make a video of basic issues we face in live please
@NestorAdrianzen3 жыл бұрын
Thanks for you question, Raghu. Do you have a specific topic in mind?
@raghunadhamara62433 жыл бұрын
@@NestorAdrianzen sry but I don't have any specific topic
@zeroskiing3 жыл бұрын
Keep making videos.....
@NestorAdrianzen3 жыл бұрын
Thank you, I will.
@ShrutiIyer884 жыл бұрын
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
@NestorAdrianzen4 жыл бұрын
Hey, Shruti! Yes, you are correct!
@talehshafaggatov1973 жыл бұрын
@@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?
@spoiltbrat553 жыл бұрын
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..
@NestorAdrianzen3 жыл бұрын
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.
@raghunadhamara62433 жыл бұрын
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
@NestorAdrianzen3 жыл бұрын
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!
@raghunadhamara62433 жыл бұрын
@@NestorAdrianzenthanks for the responce yes, I check all the rls and and shared it but still it happening.
@prabhatdass61844 жыл бұрын
Last measure even if we do not use all function would have given the same result.
@NestorAdrianzen4 жыл бұрын
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.