Turn off feature whereby groups in filter are removed based on another filter

[jacques_412]

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?

[Sahir_Maharaj · Accepted 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()
)