calculated column row subtotals

[GertjanBoersma]

Hi, 

I've  created a calculated column (combined kg) with the following DAX code:

Combined kg =

IF(Sheet1[Department] = "A",

Sheet1[planned KG],

CALCULATE(SUM(Sheet1[planned KG]), FILTER(Sheet1, Sheet1[Department] = "B" && Sheet1[Contract + line] = "123456 789")) -

CALCULATE(SUM(Sheet1[planned KG]), FILTER(Sheet1, Sheet1[Department]= "A" && Sheet1[Contract + line] = "123456 789"))

)

it gives me the result presented in the table:

for this contract the dax code works perfectly but for the whole table i need a dynamic filter on  "contract + line"

Can anyone help me?

Context  info: The main contract is given by department B. If department A gives a vendor an underlying contract the number of kilo's is reduced on contract from department B. 

[Anonymous]

Hello @GertjanBoersma 
If I get you correctly you want to change the "Contract + Line" value dynamically as per filter selection?
If yes you can use the SELECTEDVALUE in measure.
Please let me know if you're expecting something else.

[GertjanBoersma]

Hello @Anonymous, 

It's not used for a measure but for a calculated column. In my table i have multible contract from different contracts. that's why i need a dynamic filter on contract+line and department. 

If i use the SELECTEDVALUE after the && operator an error accured.  Can  you show me the dax code?

gr

[Anonymous · Accepted solution]

Hello @GertjanBoersma ,
Check out these links it may help you.
Link 1 
Link 2