Forum Discussion
Conditional formatting in function to subtotal
Good afternoon I am working with a matrix that returns sales progressions from the previous year (EJ: current month / same month previous year). I need to create a conditional format that hi...
Remember that in a matrix visual your values are calculated four times. For the individual cells, for the row total, the column total, and the grand total.
So in your case you need a measure that only calculates the column total, ignoring the DescripcionRubro field.
something like
CALCULATE([Ventas Totales],SAMEPERIODLASTYEAR(Calendario[Date]),REMOVEFILTERS(table, table[DescripcionRubro]))
That will be your column total that you can compare your current value to and then from that you can drive the conditional formatting.
Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good) if you like more assistance.