Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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])))
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])))
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |