Get total up to and including currently selected date in slicer

[jreade]

I have a table with user registration dates. Each row in the table is the date the user registered. Counting all the rows in the table will give you all the users that registered. When I add a date slicer to this report I can get all the users that registered within a specified timeframe. Now what I am trying to get is the number of users that registered up to and including that last date in selected in the slicer.

For example:

Registered_on

2017-01-20

2017-01-21

2017-02-15

2017-03-16

If 2017-02 is selected the number of users registered in that month is 1 but the total number of users registered up to that point is 3. How do I get something to return 3?

I know I can get a total all time registered using ALL to get 4.

Thank you,

[jreade · Accepted solution]

I think I figured it out... I created the following measure:

Total Registered Users = CALCULATE(COUNTROWS(users_table),FILTER(ALL(users_table),users_table[user_registered]<=MAXX(users_table,users_table[user_registered])))

[jreade]

https://community.powerbi.com/t5/Desktop/Using-the-displayed-date-slicer-for-measure/td-p/119835

This posted helped me a lot. Took me a long time to find a post like this.