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 

Microsoft v-haibl-msft
Microsoft

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,864)