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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
DZB086
Frequent Visitor

Measure showing wrong subtotals

Hey guys!

 

First off I'm fairly new to Power BI and not a native speaker.

I've got some wrong data (or more like I need other data calculated) by using a matrix chart and measures.

This diagram shown below is my matrix.

Unbenannt.PNG

 

and Data:

DZB086_0-1688565686464.png

 

PLANTIME(Planzeit) and COWORKERS_COUNT(Anzahl Mitarbeiter) are fine. Their totals are all in all fine.
My problem is that the last colum is the sum of PLANTIME * COWORKERS_COUNT which works, but the total are also being calculated by multiplying their totals.
What I need is "just" to sum up my last column (GesamtPlanzeitJeMaßnahme) for the rowtotals what Im struggling with. I guess one of my main issue is the nested matrix I have to use.

So far my measure looks something like this:

DZB086_1-1688565838329.png


image.png

 

 

 

 

I hope you can help me.

Best regards,
Davina.

1 ACCEPTED SOLUTION
DZB086
Frequent Visitor

Ok, I managed to get it by myself.

DZB086_0-1688653385587.png

I just had to summarize over my entire nested matrix values.

View solution in original post

1 REPLY 1
DZB086
Frequent Visitor

Ok, I managed to get it by myself.

DZB086_0-1688653385587.png

I just had to summarize over my entire nested matrix values.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.