Forum Discussion
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 Remaini...
viji_rajaraman , Try like
Past Due = CALCULATE(SUM (Query1[PO Remaining QTY]),filter( Query1, (Query1[OCD-PF] * Query1[CRD-PF])= 0))
Past Due = SUMX( Query1, IF ( Query1[OCD-PF] * Query1[CRD-PF] = 0, Query1[PO Remaining QTY] ) )