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
Pat. First... I am sorry I did not try this earlier. I believce I missed it.
It seems to work 🙂
Not yet sure why it work yet. Hopefully the video will fill in the gaps.
Not sure I would have gotten this on my own,.