Hi @Heather ,
thanks for your solution.
I was wondering if I could avoid using filters in the UI and solve this in DAX.
What I was thinking is using the selected values in the slicer to intersect with the proper column in the fact table, but I cannot get a table to use as a parameter in INTERSECT or TREATAS from the
Result =
CALCULATE(
[Measure],
TREATAS(
ALLSELECTED( DisconnectedTable[Column] ), << this of course doesn’t work
FactTable[Column]
)
)