Forum Discussion

mukhan169's avatar
mukhan169
Helper III
7 years ago
Solved

Another Running Total Question

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 s...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    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

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

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's avatar
    mukhan169
    Helper III
    7 years ago

    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])
    )
    )