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
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 ?
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]))
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
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.
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) ?
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...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
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
I have been struggling with this concept and this explanation with examples is the best!!
Thanks keep learning
Your way of teaching is last stop for beginner :)
Thanks keep learning
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
Will make a video on this soon
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 ?
Amazing......... Best Regards From Mexico.
Thanks keep learning. Share this channel with friends and colleagues
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]))
thank you again best teacher
Thank you great student.
Keep learning. Share this channel with friends and colleagues
Thank you , It's very clear .if it's possible please do more video's on Dax functions at High level.
Almost 45+ videos there in DAX playlist which covers more than 60 DAX functions. This is enough to handle 90% of the business scenerios
Thank you for the brief explanation
You are welcome!
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
Check power bi model videos
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.
We are working on it. We will keep uploading soon.
Can this function work with measures?
Thanks keep learning share this channel with friends and colleagues
How to use allexcept function in between tables ..I mean two tables...
Not sure what is your question
Nice explanation
Pls make a video on dynamic Top N function.
Check channel playlists
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) ?
It shouldnt be , will check
finished watching
Glad to help
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...👌👌👌👌👌👌👌👌💐💐💐💐🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂🎂
Yes, sure
@@AnalyticswithNags thanks
Thanks for this.!
Thanks keep learning share this channel with friends and colleagues
Thanks very much
Welcome
How to use allexcept (), within IF() condition?
can you elaborate your requirement. or Email your requirement with more explanation to analyticswithnags@gmail.com
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
How your both table are associated ?
Query Join or PBI ?
Nice explanation..
Thanks for liking
Please change microphone which you had used.
Check the New videos
Thanku sir
Thanks keep learning share this channel with friends and colleagues
All function removes all the filter from the table..that’s the crux
Yes that’s true
Tamil video illaiya
will do if time permits