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 want a measure to count user subscriptions with DISTINCTCOUNT per month, and bring the sum of the monthly results per year, but not DISTINCTCOUNT per year. This is because there are users who subscribe month after month and I want to count them once each month, but maximum one time per month if they subscribed more than once during a month.
Per user, there is a start date. I DISTINCTCOUNT the number of users who's start date falls between the min and max dates of the chosen period. This works fine for weeks and months, but not the year. I tried using SUMX to sum over the months, but it doesn't work.
I have a Datetable, with no relationship to the subscription_activities table.
I have a measure like this:
subscriptions=
subscriptions | Month Year (from Date table) |
1000 | January 2020 |
200 | February 2020 |
100 | March 2020 |
Total: 3300 |
Solved! Go to Solution.
It worked after I creted a new measure like this:
subscriptions_unique =
It worked after I creted a new measure like this:
subscriptions_unique =
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |