cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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 

Highlighted
v-haibl-msft Super Contributor
Super Contributor

Re: Power BI DAX IF not working exactly

@jibran

 

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,
Herbert