topic How to given percentage value in Dax function in DAX Commands and Tips

How to given percentage value in Dax function

Anonymous — Thu, 03 Feb 2022 06:24:04 GMT

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

Re: How to given percentage value in Dax function

ValtteriN — Thu, 03 Feb 2022 06:53:44 GMT

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.

Re: How to given percentage value in Dax function

V-lianl-msft — Tue, 22 Feb 2022 07:02:32 GMT

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.