topic Re: calculated column row subtotals in DAX Commands and Tips

calculated column row subtotals

Anonymous — Tue, 06 Apr 2021 11:56:21 GMT

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.

Re: calculated column row subtotals

Anonymous — Wed, 07 Apr 2021 05:24:24 GMT

Hello Anonymous
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.

Re: calculated column row subtotals

Anonymous — Wed, 07 Apr 2021 06:20:10 GMT

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?

Re: calculated column row subtotals

Anonymous — Thu, 08 Apr 2021 05:33:32 GMT

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