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. Dax for % Vol MS is: SUM('all-categories'[Sales units])/ CALCULATE(SUM('All-Categories'[Sales units]),ALL('All-categories'[BRANDS]))*100.

 





4 Replies

  • m3tr01d's avatar
    m3tr01d
    Icon for Continued Contributor rankContinued Contributor
    4 years ago

    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?

  • 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