Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@jochendecraene , try a measure like this
max Occ =
sumx(summarize(Table,Table[Year],Table[Month], "_1",[ms_max_occupation_month]),[_1])
@jochendecraene , try a measure like this
max Occ =
sumx(summarize(Table,Table[Year],Table[Month], "_1",[ms_max_occupation_month]),[_1])
Yes, this is important, so I will do this for sure. But hey, I'm a noob, so it is a bit intimidating. 😉
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |