How to given percentage value in Dax function

[Anonymous]

 i am getting error when i am trying given < 1% .   i writen condition  of Adj % values greater then 1% its use the value No touch and Use BI column. But i am  not able to 1% in the below Measure . 

No touch New = IF(AND([Adj %]<1,[Active SPD]="Active SPD"),"No Touch","Use BI")

also i am trying to give color code above measure if No touch  its Green and Use BI  its Black .

Looking for support. thanks in advance ..

[V-lianl-msft]

Hi @Anonymous ,

Based on your description, I guess you want to display two values in different formats in a measure?

Try using an external tool (Tabluar Editor)

https://community.powerbi.com/t5/Community-Blog/Using-a-slicer-to-show-different-measures/ba-p/1724504 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ValtteriN]

Hi,

I am not sure I understood the issue, but you are describing that you should have < 1% as a condition? Now you have <100%. Try changing "[Adj %]<1" ->"[Adj %]"<0,01 like this.