Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I've created a calculated column (combined kg) with the following DAX code:
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.
Solved! Go to Solution.
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.
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
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |