Forum Discussion
Using ALL function
Hello Experts,
I want here to get % of sub class food from the grand total. but in this colum there contain item that I dont want to show which is Others and I exculded when you see in filter pane, and I attach my dax commands, how I can solve this problem to get a correct % with exculding Others item.
Hi, Anonymous
You can try the following methods.
Measure = [Value]/CALCULATE([Value],ALLSELECTED(Commercial_Exports[sub_class_food]))Is this the percentage you would expect to get after removing Others?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Replace ALL with ALLSELECTED
It's hard to say what's wrong with the tool tip. You may need a different measure, not sure. The hover event of the tool tip passes filters from the visual to the card. You will just need to write some test measures on the card to work out what is going on.
Hi, Anonymous
You can try the following methods.
Measure = [Value]/CALCULATE([Value],ALLSELECTED(Commercial_Exports[sub_class_food]))Is this the percentage you would expect to get after removing Others?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
