Same measures in two fact tables. How can I create a visual that compares the two?

[brian0782]

I have the following model where I am attempting to compare figures in UAT and Production. The table schema is identical and I have already create a Combined calculated table using a full outer join in DAX.

I am trying to achieve a set of visuals where the user can easily see if the figures are matching between the two environments. Something similar to this: 

Ideally I'd like to use the tables I have in place without creating another calculated table to achieve this. Is this possible?

[_AAndrade]

Hi,

As far as I can see I think it's possible. You have two dimensions tables that are filtering both fact tables, so it's possible to do it.
You need to create a measure for Producion, another for UAT and one to calculate the difference.

If you need any help, please share more information or a pbix with an example.

[brian0782]

Yes I was thinking about that but I think it would result in this sort of visual 

I think I need the values pivoted by environment

[_AAndrade]

You need some aggregation group to filter both tables. In that way you can write your measures like I said before and it will work.
It depends on where the data in the first column comes from

[brian0782 · Accepted solution]

So I've pretty much done this now by creating a manual table and adding a calculated column: 

I think this might work