Forum Discussion

aktripathi2506's avatar
aktripathi2506
Helper IV
9 years ago
Solved

Calculating Measure

Hi,   I have this following situation where I want to calculate = Sum of (product sale by group)/Sum of Total product in Group   From this data, desired output is: = (599/2332) = 0.25   Thanks ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    9 years ago

    This will give you the result you say you want, regardless of what/where you filter.  Not sure if that is what you are after though

     

    New Measure = DIVIDE(
                    CALCULATE(
                        SUM(Table1[Product sale by Group]),
                        ALL('Table1')
                        )
                       ,                    CALCULATE(
                        SUM(Table1[Total product in group]),
                        ALL('Table1')
                        )
					)
DoubleJ's avatar
DoubleJ
Solution Supplier
9 years ago

Hi

 

Not sure if I got you right. The formula of your measure would be:

 

=DIVIDE(
     SUM(product sale by group),
     SUM(Total product in Group),
     0)

Hope this helps

JJ