Forum Discussion
Conditional formatting matrix table where column/row values are different
djanszentql it is really great question and here is the solution, I broken down the measures in small pieces to easily understand the solution, ofcourse all this can be done in one measure as well, there are 5 measure and final KPI Color measure return the color which will be used to highlight the row
Sum of Amount = SUM ( Amount[Amount] ) Sum of Servers = CALCULATE ( [Sum of Amount], ALLSELECTED( Amount[Server] ) ) # of servers = COUNTROWS ( CALCULATETABLE( VALUES ( Amount[Server] ), ALL ( Amount ) ) ) Avg by Server = DIVIDE ( [Sum of Servers], [# of servers] ) KPI Color = IF ( [Sum of Amount] <> [Avg by Server], "Red" )On value section, choose drop down menu next to Amount to do the conditioal formatting to use KPI Color measure
djanszentql here you go, single measure except # of Server count is kept seperate since that will be used in all the measures
KPI Color Single Measure =
VAR __sumofAmount = SUM ( Amount[Amount] )
VAR __sumofServers =
CALCULATE (
SUM( Amount[Amount] ),
ALLSELECTED( Amount[Server] )
)
VAR __avgbyServer =
DIVIDE (
__sumofServers,
[# of servers]
)
RETURN
IF ( __sumofAmount <> __avgbyServer, "Red" )
djanszentql amount would be config_value, run_value, maximum and minimum, so you will have four measure for each column and replace amount with these columns in your measure.
ahh okay perfect. Thank you so much!
djanszentql awesome. Good luck. Kudos help 😁😉
