Find the Difference in the totals

[GEN3Electric]

My opperational software produces 4 different reports based on Revunue. I would expect the totals of these reports to match. But they don't. I built a report in powerbi that show me these 4 report by invoice #. Is there a way  for the reort to only show me the records that do not match?

 

[jahida]

MatchMeasure = Table1[Total1] = Table1[Total2] && Table1[Total2] = Table1[Total3] && Table1[Total3] = Table1[Total4]

And then filter for MatchMeasure = False?

[GEN3Electric]

The 4 Total are comming out of different tabels. Can you do this?

MatchMeasure = Table1[Total1] = Table2[Total2] && Table2[Total2] = Table4[Total3] && Table3[Total3] = Table4[Total4]

I have not used filters. Is "MatchMeasure = False?" a separated measure?

[jahida · Accepted solution]

Yep that should also work fine.

Use the Visual (or page or report) filter menus on the right:

Looking at it now, seems like the filtering for Logical values of measures doesn't work (and also my first formula wasn't a valid measure), so it's probably better to do:

MatchMeasure = (SUM(Table1[Total1]) = SUM(Table2[Total2]) && SUM(Table2[Total2]) = SUM(Table4[Total3]) && SUM(Table3[Total3]) = SUM(Table4[Total4])) + 0

and then you can drop MatchMeasure into the side menu and filter for is 1 (use the dropdown showing "is less than" and pick "is")