Hi, @rockdotnet
You can try the following methods.
Measure = CALCULATE(COUNT('Date'[Date]),ALLEXCEPT('Date','Date'[Month],'Date'[Year]))
Please check the attachment.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @rockdotnet
You can try the following methods.
Measure = CALCULATE(COUNT('Date'[Date]),ALLEXCEPT('Date','Date'[Month],'Date'[Year]))
Please check the attachment.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What is your measure for Totals days in Month? Do you have a date table?
I would add a logical test to the measure to check if there row is a month or not and then return a different calculation when on the totals row.
Good explanation here
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
User | Count |
---|---|
142 | |
61 | |
61 | |
58 | |
49 |
User | Count |
---|---|
139 | |
71 | |
63 | |
62 | |
55 |