Cumulative sum of a measure on line chart

[Anonymous]

Hi there,

I have following measure that counts distinct clients for a condition:

M1 = CALCULATE(DISTINCTCOUNT(table(client_id), filter(table,table[Served?] ="Yes" )) 

I want to show cumulative sum values over months(I have a datedim table) of this measure on a line chart.

Please suggest how can I do it?

My sample pbi file: https://1drv.ms/u/s!Ag919_pO_UKrgQbUO5qfsTPxwfY8?e=gmwvsD

Thanks in advance.

[Anonymous · Accepted solution]

This is resolved!. Solution is :

CALCULATE(DISTINCTCOUNT(clientid), FILTER(ALL(Datedim[Date]),Datedim[Date] <= MAX(testtable[date])), testtable[served]="Yes" )

[AlB]

Hi @Anonymous 

Place YEar-Month in the axis of the visual and use this measure:

M1 =
CALCULATE (
    DISTINCTCOUNT ( table[client_id)] ),
    FILTER ( table, table[Served?] = "Yes" ),
    FILTER ( ALL ( DateTable ), DateTable[Date] <= MAX ( DateTable[Date] ) )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous]

@AlB Sorry this solution doesn't provide Cumulative sum, it just gives the distinct count. Please check the sample pbi that I have now provided in the post.

[Anonymous]

@Anonymous Find a sample report here

Appreciate your kudos!! Mark my post as solution if this works.

[Anonymous]

@Anonymous sorry I dont have access to the location of the file you shared. Is there any other way that you can share the file?

[Anonymous]

@Anonymous  Try accesing this link - PBIX 

Appreciate your kudos!! Mark my post as solution if this helps.

[Anonymous]

@Anonymous thanks for resharing the link. But it doesnt provide me with the solution I am looking for. I need a dax to get cumulative sum of a measure not a column. I have attached my sample pbi.