topic Re: Using ALL function in DAX Commands and Tips

Using ALL function

Anonymous — Thu, 02 Jun 2022 06:55:33 GMT

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.

Re: Using ALL function

MattAllington — Thu, 02 Jun 2022 07:00:33 GMT

Replace ALL with ALLSELECTED

Re: Using ALL function

Anonymous — Thu, 02 Jun 2022 07:52:36 GMT

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

Re: Using ALL function

MattAllington — Thu, 02 Jun 2022 08:06:27 GMT

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.

Re: Using ALL function

Anonymous — Thu, 02 Jun 2022 08:21:33 GMT

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

Re: Using ALL function

v-zhangti — Wed, 08 Jun 2022 08:36:25 GMT

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.