Calculation Error in measure while calculating values for Sum of entire date data and single value

[Anonymous]

Hi All, 

I am new to power bi and I am trying to build a report which has two datasets involved.  data sets are mentioned below. 

1. Long_Term_Data: this data consists of multiple columns for the same date which I need to sum up. 

2. Excel sheet: where I have projected data for the day (Single entry against each date). 

I am trying to create a difference between the sum of Long_term_data - Projected data for each date. 

Here is the DAX function I tried but it is returning an error: 

Column2 minus ALL =

CALCULATE(VALUES('Sheet1'[Column2]) - SUM('MLP_PREDICTION_LONG_TERM'[ALL]))

Below is my table and relationships 

Long_Term_Data table 

Projected table 

I have Relationship between those tables as below. 

Long_Term: Projected data ----> PDate ---->Date  Many to one 

Any help is really appreciated 

[VahidDM]

Hi @Anonymous 

Understand you want to calculate the difference for each date, so you used the Date in the visual.

try this:

Column2 minus ALL =

MAX('Sheet1'[Column2]) - SUM('MLP_PREDICTION_LONG_TERM'[ALL])

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

Appreciate your Kudos!!