Cumulative count for Distinct IDs along with slicer

Anonymous — Thu, 15 Mar 2018 18:16:49 GMT

Hi Guys,

Need your help...!

I have one scenario, where we have to show cumulative count for Disctinct IDs on year -Month. And it should display for last 2 Years, however count suppose to be taken from beginning of the date(Contains data from 2012) and it will filter the data based on slicer or Visual filter.

I can able to achive cumulative count by using below expression but slicer on Category is not working.

Measure = CALCULATE(DISTINCTCOUNT(Sheet1[Order ID]),FILTER(ALL(Sheet1),Sheet1[Order Date]<=max(Sheet1[Order Date])))

So, created another measure having below expression,

Measure = CALCULATE(DISTINCTCOUNT(Sheet1[Order ID]),FILTER(ALLSELECTED(Sheet1),Sheet1[Order Date]<=max(Sheet1[Order Date])))

it is filtering the data based on slicer but count is taking from last 2 years only, this is not what we are expecting. Please find below screen shot for reference.

Any help would be appricated.

topic Cumulative count for Distinct IDs along with slicer in DAX Commands and Tips

Cumulative count for Distinct IDs along with slicer