Forum Discussion

AOT's avatar
AOT
Frequent Visitor
6 years ago
Solved

Conditional Column using DAX not working properly

I am trying to create a new conditional column with DAX using IF()

This does not seem to be working for me.

Below is my DAX query

 

And this is a screengrab of the results I got:

 

Can I get help with why the other conditions do not pull through?

 

Thanks!

 

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    You want to use 0,10  and 0,25.

    because they are percentages. And power bi stores 25% as 0,25.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    You want to use 0,10  and 0,25.

    because they are percentages. And power bi stores 25% as 0,25.

    • AOT's avatar
      AOT
      Frequent Visitor

      Anonymous  That worked. Thanks!