Forum Discussion
Solved
Enable visual interaction without relationship
Hello dear members. I need your help. I have a matrix and a bar chart. The matrix and the bar chart uses the same measure in the values but in the rows they use different fields. In the matrix I...
Hi Dimitris_Kats ,
In your scenario, the best option would be to implement this using the calculation group, rather than using the USERELATIONSHIP.
The effect is shown below.
Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !
Thank you~
Dimitris_Kats - You can perhaps make use of TREATAS or INTERSECT in a measure to create a virtual relationship.
Review this article and see if it works: https://www.sqlbi.com/articles/physical-and-virtual-relationships-in-dax/
If this helps, please mark it as a solution.
Thank you so much mark_endicott I have already tried the inactive relationship and the treatas without the desired results 😔