Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jochendecraene
Helper IV
Helper IV

Wrong total

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

Max_Occ_Month.JPG 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@jochendecraene , try a measure like this

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

View solution in original post

7 REPLIES 7
amitchandak
Super User
Super User

@jochendecraene , try a measure like this

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

@amitchandak 

 

and even more 😊

this also works for my averages with AVERAGEX!!!

 

Thanks!

@amitchandak 

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

 

Thnx!

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler 

Thnx for the info and the quick anwser!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.