Forum Discussion

LuITS's avatar
LuITS
Icon for Helper II rankHelper II
1 year ago
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'...
@Measures
  • LuITS's avatar
    LuITS
    1 year ago

    Hi, i actually had an error in my data. Thanks for your help anyways.

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
1 year ago

Corrected DAX:

  1. Measure 1: Measure 1 = DIVIDE(SUM('Table'[Quantity]), SUMX('Table', DIVIDE('Table'[Quantity], 'Table'[Goal]))

  2. 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)

  3. This ensures the total recalculates correctly as 87.5%.

 

  • LuITS's avatar
    LuITS
    Icon for Helper II rankHelper II
    1 year ago

    Hi, i actually had an error in my data. Thanks for your help anyways.