cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## Find the Difference in the totals

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?

1 ACCEPTED SOLUTION
Impactful Individual

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")

3 REPLIES 3
Impactful Individual

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

And then filter for MatchMeasure = False?

Regular Visitor

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?

Impactful Individual

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")

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors