Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Convert ISNULL case statement to DAX

Hi,

 

Looking to recreate the case statement below into Dax.  Any help is appreciated. Thanks!

 

SELECT

sum(case when ISNULL(ca.CON_NAME,'write') = 'write' and ISNULL(ca.DEC_AMT,0) > 0 then 1 else 0 end)

FROM ano.bbc CA

Need Help
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Column = IF((ISBLANK(ca[CON_Name])||ca[CON_Name] =""||ca[CON_Name]="write") &&ca[DEC_AMT]>0,1,0)

    Measure = SUM(ca[Column])

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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

1 Reply

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    Column = IF((ISBLANK(ca[CON_Name])||ca[CON_Name] =""||ca[CON_Name]="write") &&ca[DEC_AMT]>0,1,0)

    Measure = SUM(ca[Column])

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

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