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

[@JunaidAkhtarKhan-b9p]

Your way of teaching is last stop for beginner :)

[@AnalyticswithNags]

Thanks keep learning

[@cesarsaldana3429]

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

[@AnalyticswithNags]

Thanks keep learning. Share this channel with friends and colleagues

[@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.

[@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

[@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 ?

[@sandipansarkar9211]

finished watching

[@AnalyticswithNags]

Glad to help

[@aryanverma9736]

Thank you for the brief explanation

[@AnalyticswithNags]

You are welcome!

[@aziserak4743]

thank you again best teacher

[@AnalyticswithNags]

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

[@krishnaRaog21]

Nice explanation

[@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

[@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]))

[@paramgandhi6361]

Can this function work with measures?

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@bhaveshrawat1364]

Thanks for this.!

[@AnalyticswithNags]

Thanks keep learning share this channel with friends and colleagues

[@kunwarmaurya2025]

Thanks very much

[@AnalyticswithNags]

Welcome

[@HemanthKumar-lb4xt]

Pls make a video on dynamic Top N function.

[@AnalyticswithNags]

Check channel playlists

[@adventuresofvyomandkeshav3036]

Thanku sir

[@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

[@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

[@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

[@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 ?

[@sravankumar1767]

Nice explanation..

[@AnalyticswithNags]

Thanks for liking

[@vert8747]

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

[@AnalyticswithNags]

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

[@sudipsen3677]

Please change microphone which you had used.

[@AnalyticswithNags]

Check the New videos

[@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