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')
                        )
					)
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
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')
                        )
					)