Conditional Measure Show

[Aanchal]

Dear All , 

I have three Measures as expression on frontend in straight table 

Refund/Endorsement, Premium Pending and Premium Mismatch 

Trankey	Countnew	Debtors_type	days_ageing	Premium Mismatch	Premium Pending	Refund/Endorsement
22A01512|0	2	Non OEM	0-15 Days	296	296	0
22A01512|0	2	Non OEM	More than One Month	-1232	0	-1232
22A03761|4	1	Non OEM	0-15 Days	-	0	-6182.12
22A07336|0	1	Non OEM	More than One Month	-	0	-13245
22A11806|3	1	Non OEM	0-15 Days	-	47200	0
22A13117|0	1	Non OEM	16-31 Days	-	1586805	0
22A13117|4	1	Non OEM	16-31 Days	-	0	-420375.02
22A14876|0	1	Non OEM	16-31 Days	-	0	-24339

Requirement :

when it finds Premium Mismatch the columns Refund and Premium Pending should return 0. Please guide.

[QS21]

Try this in each measure expression,
For Refund - IF ([Premium Mismatch]>0,0,Refund)
For Premium Pending - IF(Premium Pending>0,0, [Premium Pending])

[Aanchal]

No , its not giving the desired output.