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.

v-zhangti's avatar
v-zhangti
Community Support
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.