Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
good morning
I have two filters. One filters by business unit, and another by job. When I filter by business, it removes all the job types that are not in that business from the second filter. I do not want it to do this. How do I stop this?
I have tried adding a calculated column that takes the max of the business unit name, thinking that a calculated column might help.
I have also tried duplicating the table, and joining on the job name, but job names aren't unique in the table so that also doesn't work.
Any ideas?
Solved! Go to Solution.
Hello @jacques_412,
Can you please try creating a new measure or calculated column in your report using the USERELATIONSHIP function:
MeasureName =
CALCULATE(
[YourMeasure],
USERELATIONSHIP(JobTable[Job], BusinessUnitTable[Job]),
ALLSELECTED()
)
Hello @jacques_412,
Can you please try creating a new measure or calculated column in your report using the USERELATIONSHIP function:
MeasureName =
CALCULATE(
[YourMeasure],
USERELATIONSHIP(JobTable[Job], BusinessUnitTable[Job]),
ALLSELECTED()
)
User | Count |
---|---|
53 | |
45 | |
19 | |
16 | |
14 |
User | Count |
---|---|
108 | |
56 | |
29 | |
21 | |
17 |