Help with measure removing a column from the context

[Quest]

Hi all,

I have a table with numerous fields and I want to show a table in my report with following fields only:

Date, Product Category, Unit

This is how my data (fields I am trying to show in my table) looks like:

Date, product category, sales unit, forecast unit

Jan , A, 10, 10

Jan, B, 15,20

Jan, C, 15,10

Feb, A, 10,20

Feb, B, 10,10

I want to derive the final table as below. Note that units in this table is the forecast unit - sales unit for a month, without considering the product category.

Date, Product category, Units

Jan , A, 0

Jan, B, 0

Jan, C, 0

Feb, A, 10

Feb, B, 10

I tried using All and AllExcept, but didnt seem to work. I could be doing something wrong. Please help me with this. 

[amitchandak]

@Quest , Try a measure like

calculate(sum(Table[forecast]) - sum(Table[Sales]), filter(allselected(Table), Table[Date] =max(Table[Date])))

[Quest]

Thanks Amitchandak for the quick response. But this does not seem to be working for me.

Date, Product category, Units

Jan , A, 10

Jan, B, 10

Jan, C, 10

Feb, A, 10

Feb, B, 10

For Jan, the data should show 0 as the difference for Jan is 0 and for Feb it should show 10.

[amitchandak]

@Quest , Please find if the attached file can help

[Quest · Accepted solution]

Thanks a lot. I didnt create it as a measure, my bad.