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