topic Re: All function not working as supposed to in DAX Commands and Tips

All function not working as supposed to

Arpit_Jain — Mon, 23 May 2022 01:15:36 GMT

Hi,
I am trying to get top-3 brands according to the price band I've set. Whenever I put in a filter of top n or try to select the brands, calculation for % Vol MS changes according to the selection. Dax for % Vol MS is: SUM('all-categories'[Sales units])/ CALCULATE(SUM('All-Categories'[Sales units]),ALL('All-categories'[BRANDS]))*100.

Re: All function not working as supposed to

m3tr01d — Mon, 23 May 2022 12:08:11 GMT

hi Arpit_Jain,

did you try using ALLSELECTED instead of ALL? I think it might solve your issue. If it doesn't work, can you give us some screenshots how when it doesn't work and what would be the right behavior?

Re: All function not working as supposed to

Arpit_Jain — Mon, 23 May 2022 17:06:30 GMT

Re: All function not working as supposed to

Arpit_Jain — Mon, 23 May 2022 17:08:46 GMT

I want % Vol MS to be constant and not change if we change the number of brands

Re: All function not working as supposed to

Anonymous — Wed, 25 May 2022 03:01:12 GMT

Hi Arpit_Jain ,

Please try ALL('all-categories') instead.

Or try this formula:

SUM('all-categories'[Sales units])/SUMX(ALL('all-Categories'),'all-Categories'[Sales units])*100

If it still doesn't work, please share sample data.

Best Regards,

Jay