Forum Discussion
How to switch the relationship a measure is using
I am using Azure Analysis Services as the data source. Is there a way to switch which relationships a measure from the cube is using from the Power BI report side or is that sometihng that has to be ...
Anonymous , if it is a live connection, not much you can do other than creating a measure. In measure, we use userelationship to switch relationships in a tabular model, not sure on the cube.
What exactly do you want to achieve.
Shishir22
Solution Sage
Solution SageHello Anonymous ,
In Azure analysis services you need to create inactive relationship which you need to activate for given measure and while creating a measure you can use Userelationship DAX function to switch inactive relationship to activate state.
https://docs.microsoft.com/en-us/dax/userelationship-function-dax
Thanks!
Please mark this post as solution if it fulfils your requirement. Kudos are also appreciated.