Forum Discussion
calculated column row subtotals
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.
3 Replies
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