Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Running total with 0 values

Hi,    I have this table in my model :   DAY_ORDER    SHIFT         WEEKDAY    QUANTITY 1 NIGHT_SHIFT_WD MON 70 1 MORNING_SHIFT_WD MON 43 1 EVENING_SHIFT_WD MON 75 2 NIGHT_...
Need Help
  • smpa01's avatar
    smpa01
    6 years ago

    Anonymous You can create an additional measuere as

     

    Measure = SUMX('Table','Table'[QUANTITY])
     
    and new measure
    Measure 2 = IF([Measure]=0,0,[QUANTITY running total in WEEKDAY])
     
smpa01's avatar
smpa01
Community Champion
6 years ago

Anonymous You can create an additional measuere as

 

Measure = SUMX('Table','Table'[QUANTITY])
 
and new measure
Measure 2 = IF([Measure]=0,0,[QUANTITY running total in WEEKDAY])
 
Anonymous's avatar
Anonymous
Not applicable
6 years ago

smpa01 Hey! That's exactly what I was looking for! Thanks for helping!! Much appreciated!