Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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,...
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    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's avatar
MattAllington
Community Champion
4 years ago

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's avatar
    Anonymous
    Not applicable
    4 years ago

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