Using ALL function

[Anonymous]

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.

[v-zhangti · Accepted solution]

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.

[MattAllington]

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. 

[Anonymous]

I want to meet you in zoom to show that to you.

[MattAllington]

Replace ALL with ALLSELECTED

[Anonymous]

in table is worked,
but I used this measure in card as a tool tipm it give each item 100% as a photo below: