Forum Discussion
DAX Conditional Formatting the maximum value for each column in a Matrix
Read about the difference between aggregators (SUM, MAX) and iterators (SUMX, MAXX). That will help you to decide when to apply which (very roughly aggregators work on columns while iterators work on rows).
Let me know when you have sorted your actual requirement out. The measure I provided is only one of many possible implementations (and a very simplistic one, too). It did work for your original request, but it's perfectly fine for requirements to change during prototyping.
This seems to be generally going in the right direction. Keep in mind that your measure is computed in each of the individual contexts. Do you want the star once for the whole table, or once for each column?
Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services.
Hi, thank you, here is an idea of the data inside the table.
I would like to just show an icon once for each column (which in this case would be once for each [GROUP]
| EAM | REVENUE | GP | GROUP |
| John | $275 | $44 | ☁️ Cloud |
| Larry | $51,556 | $5,402 | ☁️ Cloud |
| Karl | $34,048 | $5,059 | ☁️ Cloud |
| Kathy | $6,514 | $850 | ☁️ Cloud |
| Tom | $38,528 | $6,945 | ☁️ Cloud |
| John | $31,557 | ($4,097) | 🌐 Network |
| Larry | $3,500 | $301 | 🌐 Network |
| Karl | $152,191 | $26,233 | 🌐 Network |
| Kathy | $131,786 | $16,606 | 🌐 Network |
| Tom | $22,232 | $1,795 | 🌐 Network |
| John | $270,091 | $21,379 | 🔒 Security |
| Karl | $42,710 | $4,271 | 🔒 Security |
| Kathy | $31,657 | $4,605 | 🔒 Security |
Like this?
Of course the proper way would be to use RANKX() etc but that gets a little tricky with measures. You would also need to decide what to do with ties etc.
Sample pbix attached.
Thank you so much for taking the time to do that, it looks perfect, but only shows zeros on every row in the column when I drag the measure into the visual (to test and see if I get 0, 1 or 2).
Not sure what else I am doing wrong, I even cleared any filters on the visual or page etc.
Again thank you!
Please provide sanitized sample data that fully covers your issue.. Please show the expected outcome.