Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to get this expression in DAX?

How can I convert following SQL measure in DAX?

if [A]=[B] then 'TRUE'
ELSEIF [B]='All' then 'TRUE' END

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous , you can get this by 

    IF([A] = [B],TRUE(),IF([B] = 'All',TRUE(),BLANK()))

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous , you can get this by 

    IF([A] = [B],TRUE(),IF([B] = 'All',TRUE(),BLANK()))

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi  Anonymous ,

    If you want to create a new column ,you could use the following dax:

    Column = IF('Table'[A]='Table'[B]||'Table'[B]="All",TRUE(),BLANK())

    And if you want to create  a  measure ,you could try the following dax:

    Measure = IF(MAX('Table'[A])=MAX('Table'[B])||MAX('Table'[B])="All",TRUE(),BLANK())

    Final you will get :

     

     

    Wish it is helpful for you!

     

    Best Regards

    Lucien