Power BI DAX Tutorial (14/50) - What is ALL and ALLExcept

[@SoundBenda-ug1bz]

I have been struggling with this concept and this explanation with examples is the best!!

[@AnalyticswithNags]

Thanks keep learning

[@mohanasivakumarvarma7728]

your explanation is fantastic on these ALL and ALLEXCEPT ,no doubt about it. It would have been more better if you could give more explanation on context query, outside query and inside query but overall I feel happy after listening your lecture

[@AnalyticswithNags]

Will make a video on this soon

[@vitthalchavan7578]

Column names are missing for sales table that dataset you had provided for Practice.

[@AnalyticswithNags]

Thanks for highlighting.

[@JunaidAkhtarKhan-b9p]

Your way of teaching is last stop for beginner :)

[@AnalyticswithNags]

Thanks keep learning

[@bornmodel3708]

I found is very useful, you are doing wonderful job for all. I simply loved it, please keep helping us. I am eagerly waiting for you DAX remaining part, I mean 16/50 to 50/50.

[@AnalyticswithNags]

We are working on it. We will keep uploading soon.

[@siddheshdandagavhal9804]

ALL v/s ALLEXCEPT ALL removes all filter context applied on the data (ex: Calculate([Total Sales], ALL(Sales)) ALLEXCEPT removes all filter context except the mentioned fields. (ex: Calculate([Total Sales], ALLEXCEPT(Sales, Sales[Product Category]))

[@cesarsaldana3429]

Amazing......... Best Regards From Mexico.

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@aziserak4743]

thank you again best teacher

[@AnalyticswithNags]

Thank you great student. Keep learning. Share this channel with friends and colleagues

[@mr.prasadyadav]

Thank you , It's very clear .if it's possible please do more video's on Dax functions at High level.

[@AnalyticswithNags]

Almost 45+ videos there in DAX playlist which covers more than 60 DAX functions. This is enough to handle 90% of the business scenerios

[@aryanverma9736]

Thank you for the brief explanation

[@AnalyticswithNags]

You are welcome!

[@DIVI-EXP]

I know we are using All fx here but just a query noob one though if we use % cat sales=DIVIDE(SUM(Sales[Total Sales]),[Total Sales]) will it give the same value as using All fx here ?

[@krishnaRaog21]

Nice explanation

[@sandipansarkar9211]

finished watching

[@AnalyticswithNags]

Glad to help

[@mahadevshingade1822]

very good explanation sir now its cleared request to you could you please guide on how to work with large amount of data in power bid like data with more than 10 millions rows

[@AnalyticswithNags]

Check power bi model videos

[@bhaveshrawat1364]

Thanks for this.!

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@ashishmohan4707]

Hi very useful video and very practical need everyone for every project ......very big thanks to share with us. If it can possible can you plzz provide us excel data file which you used. Very greatful for us...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂

[@AnalyticswithNags]

Yes, sure

[@ashishmohan4707]

@@AnalyticswithNags thanks

[@HemanthKumar-lb4xt]

Pls make a video on dynamic Top N function.

[@AnalyticswithNags]

Check channel playlists

[@kunwarmaurya2025]

Thanks very much

[@AnalyticswithNags]

Welcome

[@paramgandhi6361]

Can this function work with measures?

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@sivan589]

How to use allexcept function in between tables ..I mean two tables...

[@AnalyticswithNags]

Not sure what is your question

[@sravankumar1767]

Nice explanation..

[@AnalyticswithNags]

Thanks for liking

[@adventuresofvyomandkeshav3036]

Thanku sir

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@vert8747]

How to use allexcept (), within IF() condition?

[@AnalyticswithNags]

can you elaborate your requirement. or Email your requirement with more explanation to [e-mail]

[@husspirit]

Hi, If i have 2 allexept in the calculate formula , does the order matters ? Example : Allexcept(city ), Allexept( country ) is different from Allexcept(country ), Allexept( city) ?

[@AnalyticswithNags]

It shouldnt be , will check

[@sudipsen3677]

Please change microphone which you had used.

[@AnalyticswithNags]

Check the New videos

[@SunilKumarMutte]

Hi, first thing I would like appreciate for the video, making me to understand ALL and ALLEXCEPT, I have created a measure with following formula allsalesbycountry = CALCULATE(SUMX(Sales,Sales[SalesAmount]+Sales[Freight]),ALLEXCEPT(Territory,Territory[Country])) I have a doubt, now I have a column "Gender" from another table "customers", if there is a slicer with gender, when I click on Male or female using slicer, data is getting updated in "allsalesbycountry", so please clarify how to avoid filtering another column from another table also? Thanks in advance

[@AnalyticswithNags]

How your both table are associated ? Query Join or PBI ?

[@gaganhs9242]

All function removes all the filter from the table..that’s the crux

[@AnalyticswithNags]

Yes that’s true

[@jayachitramanivannan3642]

Tamil video illaiya

[@AnalyticswithNags]

will do if time permits