Forum Discussion
Cross-Filtering a Visual Based on an Inactive Relationship
I have an ative relationship between a date table and a dimension table based on the processing date and an inactive relationship based on the due date. I've created a Measure that allows me to c...
HI Paul_Rockliffe,
Do you mean you have multiple inactivated relationships need to be switched based on the selections to dynamic affect the calculation results?
If that is the case, I'd like to suggest you setting and what if parameter table with all type of relationship names. Then you can write measure formula with switch function to return different calculation formulas based on current selection.
Regards,
Xiaoxin Sheng