Running total till date

[Anonymous]

Hi,

I want help with the running total till date iam getting the total throughout the whole year i have tried every possible solution but has nothing worked.If i get help it would be really appreciated.

FY ends 06/30, FYmon is FY month no.

Actual_MM1 = CALCULATE(CALCULATE(COUNT(FTE[ACTUALDATE]), FTE[activitycodedescription]="Mass Mailing 1"))

YTD= CALCULATE(COUNT(FTE[ACTUALDATE]),FTE[activitycodedescription]="Mass Mailing 1" ,FILTER(ALLSELECTED(FTE),FTE[FYmon]<=MAX(FTE[FYmon]) )when i select current fiscal year the total should stop till september but it goes till end of the year .

[v-yuta-msft · Accepted solution]

@Anonymous ,

Modify your measure using dax below and check if it can meet your requirement:

YTD =
CALCULATE (
    COUNT ( FTE[ACTUALDATE] ),
    FILTER (
        ALLSELECTED ( FTE ),
        FTE[activitycodedescription] = "Mass Mailing 1"
            && FTE[FYmon] <= MAX ( FTE[FYmon] )
    )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.