Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Ponderation

Hello. I have a table for sellings like this:

 

Product%Montly var
Hammer20-33%
Cutter176%
Others7390%

 

In the cell % I have the total, but with the option "show as porcentaje". The thing is that the Monthly var is calculated against the total, I want it to be calculated against the % of the total.

 

How can I make a measure that equals the "Show as %" option to work agains it?

 

Thanks

Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Solved.

     

    With 

     

    %TotalSells = DIVIDE([Total Sells], CALCULATE([Total Sells], ALL(Products[all_products])))
     
    I have the measure to show the %s. I made a MoM quick measure over it and got the needed result.
     
    Thanks!!

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Solved.

     

    With 

     

    %TotalSells = DIVIDE([Total Sells], CALCULATE([Total Sells], ALL(Products[all_products])))
     
    I have the measure to show the %s. I made a MoM quick measure over it and got the needed result.
     
    Thanks!!