Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
ray_aramburo's avatar
ray_aramburo
Icon for Super User rankSuper User
2 years ago

I 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.