Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DAX Formula - DIVIDE

Hello,    I need some help with some formula that I can't put in a right way.    I need to have the participation of all categories for sales. I did the DAX formula in the right way for a table w...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try one of the two measures

     

    divide(sum(Table[value]), calculate(sum(Table[value]), all(Table)))

     

    divide(sum(Table[value]), calculate(sum(Table[value]), allselected(Table)))

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try one of the two measures

 

divide(sum(Table[value]), calculate(sum(Table[value]), all(Table)))

 

divide(sum(Table[value]), calculate(sum(Table[value]), allselected(Table)))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you. I was using divide(sum(Table[value]), calculate(sum(Table[value]), allselected(Table))) but no results on filtering and that 1st one is perfect. Thank you