Forum Discussion

Rajesh_R1's avatar
Rajesh_R1
Frequent Visitor
5 years ago

running total for specific value

Hi,   I have the below table, in which i calculated the running total. Can any one suggest how to create a seperate measure which filter only the Running total value when  SOTAT days at 1?    ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Rajesh_R1 , Try a measure like

 

Running Total % =
divide( SUMX(
FILTER(
ALLSELECTED('Daily SOTAT'[SOTAT Days]),
'Daily SOTAT'[SOTAT Days] <=MAX('Daily SOTAT'[SOTAT Days])
),
[count of SAP order No ]
), calculate([count of SAP order No ], ALLSELECTED('Daily SOTAT'[SOTAT Days])))