Conditional Formatting Percent of Column Totals in a Matrix

[comish4lif2]

I have a matrix visual and I have set "Show Value as" to "Percent of column total" and then applied Conditional Formatting. It looks nice. But it is wrong. It appears to me that the conditional formatting is using the underlying Count of the field as the driver for the conditional formatting (and not the column percentage values).

>>> How do we get the matrix to display the correct formatting? <<<

Is there a way to do this without creating a measure?

[AlexisOlson · Accepted solution]

It doesn't look like the percentage versions of the calculation are an option in the conditional formatting settings so you'll need to define a measure that gives the percentage of column total.

Such a measure would look like this:

DIVIDE (
    COUNT ( Table1[Value] ),
    CALCULATE ( COUNT ( Table1[Value] ), ALL ( Table1[Column1] ) )
)

where [Column1] is whatever you're using for your row headers in the visuals.