Forum Discussion
Getting totals to work in a complex matrix visual
I am creating a Matrix Table that estimates future work by month. Work exists in the form of a Ticket. There are two tables involved: a (1) Ticket Table and a (2) Calendar Table. The ticket tabl...
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
mahoneypat
Microsoft Employee
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 can email you a copy of the PBIX file if it woulf be helpful