Forum Discussion
Conditional formatting on tables vs matrix
Thank you for responding. I was not able to get this to work. It would help me if the ranking measure was only based on Case ID field. (Let's forget about including any other fields for now.) I am most interested in determining if the Case ID matches the one above and then formatting it.
Hi @Alicia_Anderson ,
You cannot take the other fields from your ranking measure because measures are based in context, this means that any values that you have that will impact the calculations will change the final result.
In this case if you only get the Case ID field you will get for every row a ranking from 1 to N so you will not be abble to filter out the first one of each "group". Every Column you add to your table you are adding context to your calculations so this needs to be taken into account in order to have the correct values because you have several levels of interaction.
Making this visible with values:
| CaseID | Name | Rank Based on CaseID | Rank Based on CASEID and Name |
| 1 | AA | 1 | 1 |
| 2 | BB | 2 | 1 |
| 3 | CC | 3 | 1 |
| 4 | DD | 4 | 1 |
| 5 | EE | 5 | 1 |
| 6 | FF | 6 | 1 |
| 7 | FF | 7 | 2 |
| 8 | FF | 8 | 3 |
| 9 | FF | 9 | 4 |
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.