converting sql case statement to Dax

[Anonymous]

Hi,

Does anyone know how I would convert this SQL case statement to DAX? Thanks!

sum(case when ISNULL(A.CON_CODE,'Z') = '' and ISNULL(A.DEC_AM,0) > 0
and A.APP_DEC ='C' and A.BK_DT is not null then 1 else 0 end)

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Create calculated column.

Flag =
var _first=
IF(
    'Table'[A.CON_CODE] = BLANK(),"Z",[A.CON_CODE])
var _second=
IF(
   'Table'[A.DEC_AM] = BLANK(),0,[A.DEC_AM])
return
IF(
    _first="Z"&&_second>0&&'Table'[A.APP_DEC]="C"&&'Table'[A.BK_DT] <> BLANK(),1,0)

Dax =
SUMX(
    'Table',[Flag])

2. Result:

Best Regards,

Liu Yang

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