Forum Discussion

Anonymous

Not applicable

3 years ago

Solved

Matrix total days calculation is wrong

need help with this issue

General Comment

v-zhangti
3 years ago
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.
Matrix total days calculation is wrong.pbix42 KB

4 Replies

ddpl
Solution Sage
3 years ago
Anonymous use the "HASONEVALUE" Functon for days per month column.

or

Ref : https://www.youtube.com/watch?v=VE5Ephqk7A0
NanDeb
Helper I
3 years ago
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
Anonymous
Not applicable
3 years ago
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)
- v-zhangti
  Community Support
  3 years ago
  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.
  Matrix total days calculation is wrong.pbix42 KB

Related content