cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KBUIUS
Helper I
Helper I

Maxtrix table Subtotal calculation when expand/collapse

So I have this matrix table like this. Let's look at Jul 22.

When it is collapsed, the Monthly On Time Completion % is Incorrect. It is supposed to be: 78/85 =91.7%. 

KBUIUS_1-1662560597044.png

So why does it show 71.7%?  because when I expand it, it is the Avg of the individual rows:  90+25+100/3

KBUIUS_2-1662560762415.png

 

So my question is, when I collapse it, how can I force it to show 91.7% , intead of 71.7% (as in the first picture)

 

 

2 REPLIES 2
PaulDBrown
Super User
Super User

What measures are you using?





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






no measure, it's just data from an imported table

KBUIUS_0-1662567914456.png

 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.