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],
IF(SELECTEDVALUE('Table'[Column1])="Gross Margin",FORMAT([Gross Rev.Margin],"Percent")))
Now I want to do Conditional Foormatting for the above measure.The Condition is as follows
If([Test] <0 ,"Red","Green")
If([Test] <0 ,"Red","Green")
With the above measure the conditional Formatting is effecting only Sales(It's currency Value) but not the Gross Margin.(it's in Percentage)
Is there any way to achieve this?
TIA
Is there any way to achieve this?
TIA
1 Reply
- ray_aramburo
Super User
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.
