Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |