Forum Discussion
Solved
DAX Measure, Total is wrong
Hello I have problems converting formulas into DAX measure, Measure 1: SUM(Quantity) / SUM( Quantitiy / Goal ) My try: DIVIDE('Table'[Quantity], SUMX('Table', DIVIDE('Table'[Quantity], 'Table'...
Hi, i actually had an error in my data. Thanks for your help anyways.
Corrected DAX:
-
Measure 1: Measure 1 = DIVIDE(SUM('Table'[Quantity]), SUMX('Table', DIVIDE('Table'[Quantity], 'Table'[Goal]))
- Measure 2 (Fix Total): Use SUMX to correctly calculate the total: Measure 2 = VAR TotalQuantity = SUM('Table'[Quantity]) VAR TotalOtherMeasure = SUM('Table'[Other Measure]) VAR TotalMeasure1 = DIVIDE(TotalQuantity, SUMX('Table', DIVIDE('Table'[Quantity], 'Table'[Goal])))
RETURN DIVIDE(TotalOtherMeasure, TotalMeasure1) - This ensures the total recalculates correctly as 87.5%.
Hi, i actually had an error in my data. Thanks for your help anyways.