Forum Discussion

viji_rajaraman's avatar
viji_rajaraman
Frequent Visitor
4 years ago
Solved

sum based on calculated condition

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

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    viji_rajaraman , Try like

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

  • johnt75's avatar
    johnt75
    Super User
    4 years ago
    Past Due = SUMX( Query1, IF ( Query1[OCD-PF] * Query1[CRD-PF] = 0, Query1[PO Remaining QTY] ) )