Forum Discussion
Conditional formatting a percentage based on other column
I think if you could provide a sample of your data set would be helpful.
Especially since I can't see how you could have two columns with the same name in Power BI.
Later edit: Try to create two separate measures, 1 for Real% January and one for Real% February. Maybe it will work.
Resident RockstarNow your formula seems right, so if is not working we need take a look the data and data model to underdtand what is wrong.
If you could Share a pbix file I could take a look.
If it's not possible, try to debug your formula putting the formula on the matrix and see what is returning.
For example, create a measure only with MAX( table REAL%) and see what this formula returns on the matrix.
And after do it the same for the other MAX funcion.
This is what I would do.
I hope this can help you to solve your problem.
Seems like the MAXX colouring is based on the total, not the Std for each individual row.
Let me try to change my data to something generic so I can share a pbix file