Showing results for 
Search instead for 
Did you mean: 
jibran Regular Visitor
Regular Visitor

Re: Power BI DAX IF not working exactly

Hi Herbert,

Actullay the desired result is that to match total credit with total debit based on vehicle ID (Which has already been achieved with your help). But I want to match the Credit cost with debit cost at line level. So in case of 1129 "60.00" matches with debit side "60.00" and if matches it shows 0.

If this can not be achieved then can I put filter on equal2 formula (i.e. show me "0" or shown me "-1" only)


Many Thanks


Jibran Ishtiaq 

v-haibl-msft Super Contributor
Super Contributor

Re: Power BI DAX IF not working exactly



Could you please give me a sample in your PBIX which should return 0? In 1129, I do not see any equals as below.

Power BI DAX IF not working exactly_1.jpg


Best Regards,