Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 =
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
181 | |
85 | |
69 | |
62 | |
55 |