Forum Discussion
Solved
Matrix Subtotal Highlight
I have the matrix table like below photo Those highlighted in yellow are my row subtotals. Those in Blue font are my column subtotals. Is possible to extend my highlight up to the column ...
Hi mussaenda,
Please try like this:
Measure = var a = CALCULATE(SUM('Table'[Sales]),ALLSELECTED('Table'[Segment])) return IF([Total Sales] = a,"RED",BLANK())
Hi mussaenda ,
We need to use at least April 2020 version of Power BI Desktop to use it. You could download a latest one from: https://www.microsoft.com/en-us/download/details.aspx?id=58494.
Reference:
Finally, I found it.
Thank you v-xuding-msft !
But what I wanted to do is only highlight the column total where there is row subtotal.
On the photo I attached before. I have highlighted the whole row subtotal. But the total of the row subtotal is what I want to highlight only.
Would that be possible?
Hi mussaenda,
Please try like this:
Measure = var a = CALCULATE(SUM('Table'[Sales]),ALLSELECTED('Table'[Segment])) return IF([Total Sales] = a,"RED",BLANK())