Trying to ma the difference between 2 columns in different tables in a measure

PeterVachon ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Need to try with data

Hi  PeterVachon ,

This is the data I created:

Sales tables:

Forecast tables:

look up tables:

Here are the steps you can follow：

1. Create measure.

alltoal =
var _select=
SELECTEDVALUE('look up table'[date])
return
CALCULATE(SUM('Sales tables'[amount]),FILTER(ALL('Sales tables'),'Sales tables'[Customer]=MAX('Sales tables'[Customer])&&'Sales tables'[Month]=MONTH(_select)))

Forecastamount =
var _select=SELECTEDVALUE('look up table'[date])
return
CALCULATE(SUM('Forecast tables'[Amount]),FILTER(ALL('Forecast tables'),'Forecast tables'[monthly]=MONTH(_select)&&'Forecast tables'[Customer]=MAX('Forecast tables'[Customer])))

Flag =
IF(MAX('Sales tables'[date]) in SELECTCOLUMNS('look up table',"1",[date]),1,0)

Flag1 =
IF(MAX('Forecast tables'[monthly]) in SELECTCOLUMNS('look up table',"1",MONTH('look up table'[date])) ,1,0)

2. Put [Flag] and [Flag1] into the Filter of the corresponding visual object respectively, is=1, apply filter.

3. Put [date] of the look up table table into the slicer, according to the selected date, to display the corresponding total sales and monthly forecast value, and compare

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.