Another Running Total Question

[mukhan169]

I apologize but searching through the forum I cant find the answer to the following question. May be my concept is not very clear. But thats how it goes, I have following table.

The measure is simple

Count without zero = COUNT(Claims[ID])

And trying to do the running total.

RunningTotal =

CALCULATE([Count without zero]|

FILTER(

ALLSELECTED(Claims)|

Claims[BMonthYear]<=MAX(Claims[BMonthYear]))

)

As you can see Its not doing the running total line by line. Its doing the total sum . Can someone please help me its seems very easy but I am pulling my hair on this.

[v-lili6-msft · Accepted solution]

hi, @mukhan169 

Just add a conditional in your formula:

&&Claims[MIS]<=MAX(Claims[MIS])

Measure = CALCULATE([Count without zero],
FILTER(
ALLSELECTED(Claims),
Claims[MonthYear]<=MAX(Claims[MonthYear])
&&Claims[MIS]<=MAX(Claims[MIS])))

Result:

Best Regards,

Lin

[mukhan169]

@v-lili6-msft 

Thank you very much. I had to change the formula so it only calculates running total for each month Year.

RunningTotal =

CALCULATE([Count without zero]|

FILTER(

ALLSELECTED(Claims)|

Claims[BMonthYear]=MAX(Claims[BMonthYear])

&& Claims[MIS]<=MAX(Claims[MIS])

)

)

[Anonymous]

So your calculation is only looking at the MonthYear column when deciding what to sum. Try making a new Column that is MonthYear and MIS(assuming they always increase and no repeats). Then replace MonthYear with the new column in your running total.

[mukhan169]

Month year is already a seprate column and you are correct MIS(Month in service ) doesnt repeat for the same Month Year.