Wrong total

[jochendecraene]

Hello

I'm trying to calucate the maximum accupation a month of our shelter.

This works fine if, the total for a year is wrong.

Can someone help me out?

Here's a screenshot of the measure and the result

 

[amitchandak · Accepted solution]

@jochendecraene , try a measure like this

max Occ =
sumx(summarize(Table,Table[Year],Table[Month], "_1",[ms_max_occupation_month]),[_1])

[jochendecraene]

@amitchandak 

and even more 😊

this also works for my averages with AVERAGEX!!!

Thanks!

[jochendecraene]

@amitchandak 

wow .. this works ... I don't know what I'm doing, but I got the result!

Thnx!

[Greg_Deckler]

Right, if you want to understand what is going on, read the links I posted as it is the same technique.

[jochendecraene]

Yes, this is important, so I will do this for sure. But hey, I'm a noob, so it is a bit intimidating. 😉

[Greg_Deckler]

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[jochendecraene]

@Greg_Deckler 

Thnx for the info and the quick anwser!