Forum Discussion
Matrix total days calculation is wrong
need help with this issue
Hi, Anonymous
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.
the Days per month is a measure. Please find below and if i go to the format visual and select row subtotals. it does not sum up correctly.
Days per Month = DATEDIFF(
EOMONTH(MAX('OSR Revenue'[Billing_Period]),-1),
EOMONTH(MAX('OSR Revenue'[Billing_Period]),0),DAY)
Hi, Anonymous
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.