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~
To avoid the filtering of auxiliary tables affecting the calculations of other tables, it is therefore preferable to disconnect the relationship.
Calculated groups are used in order to add the filtering of selected items in the bar chart to other measure, you can check the expression for calculated groups to understand this.
That makes sense. Thank you so much for the thorough explanation 😃