Forum Discussion
Getting totals to work in a complex matrix visual
Please see this video. You will need to reference your existing measure in a new measure using the pattern below (and use it in your visual instead).
(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube
NewMeasure = SUMX(VALUES(Table[TicketID]), [Your Measure])
Pat
Microsoft EmployeePlease see this video. You will need to reference your existing measure in a new measure using the pattern below (and use it in your visual instead).
(2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube
NewMeasure = SUMX(VALUES(Table[TicketID]), [Your Measure])
Pat
I changed the existing SUMX measure to: return SUMX(VALUES(TicketDataTable[Ticketid]), BusDays * PoolHrsPerCasePerBusDay)
There was no change to the Matrix visual. Incorrect totals and missing values persist.