All function not working as supposed to

[Arpit_Jain]

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.

[Anonymous]

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

[m3tr01d]

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?

[Arpit_Jain]

[Arpit_Jain]

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