Forum Discussion
Conditional for Negative number and Negative Percentage in a single measure
Hello All, I've created a table by manually entering the Data as Sales and Gross Margin as rows. And I wrote a DAX like this Test = IF(SELECTEDVALUE('Table'[Column1])="Sales",[TotalSales...
ray_aramburo
Super User
Super UserI would recommend to separate your measures or even the columns. The moment you format the percentage one it turns into text and you lose the ability to evaluate with numerical logic. So, create a separate column that formats it as text and use the numerical one to evaluate the logic.