sum based on calculated condition

[viji_rajaraman]

Hi 

I have to convert below sql to power bi measure

SUM( CASE WHEN ([CRD-PF]* [OCD-PF] = 0 ) then [PO Remaining QTY] ELSE 0 END )

POWER BI , 

Past Due = CALCULATE(SUM (Query1[PO Remaining QTY]), Query1[OCD-PF] * Query1[CRD-PF]= 0)

getting error - The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression. 

please suggest a workaround.

thanks,

Viji

[johnt75]

Past Due = SUMX( Query1, IF ( Query1[OCD-PF] * Query1[CRD-PF] = 0, Query1[PO Remaining QTY] ) )

[amitchandak · Accepted solution]

@viji_rajaraman , Try like

Past Due = CALCULATE(SUM (Query1[PO Remaining QTY]),filter( Query1, (Query1[OCD-PF] * Query1[CRD-PF])= 0))