Forum Discussion

Arpit_Jain's avatar
Arpit_Jain
Frequent Visitor
4 years ago

All function not working as supposed to

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

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