Forum Discussion
Conditional formatting matrix table where column/row values are different
- 6 years ago
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 based on you dataset it should work for every row. May be I missed something. You don't need to calculate it for every row.
Perhaps I am confused what you meant by [Amount]. I used [config_value] column in place of [Amount]. Here is the dataset. Just imagine everything censored by the red block is 'Server 1'. If you were to scroll further down you would eventually see 'Server 2' and so on.
- parry2k6 years agoSuper User
djanszentql perfect what you did to replace Amount wiht your own field, and you don't need to create seperate measure, it will work for each row in your model. Solution is global to your dataset until you see it is not working
- parry2k6 years agoSuper User
djanszentql sorry I got it what you mean, let me send your single measure for all this. sorry for the confusion.
- djanszentql6 years agoHelper I
No need to apologize. I appreciate the help. You can just call the table 'Query1' by the way. I have not renamed it.