Forum Discussion
Matrix | relationship | slicer
I figured it out. The solution was to distinct join the columns from assignment and generaloverview to a new table OwningOffice. And use the values from there.
This article helped me figure it out:
https://community.powerbi.com/t5/Desktop/Getting-distinct-values-for-multiple-columns/td-p/31997
Hello Roha,
it's obvious that your relationships are not maintained in the data model. For this reason we see the repetition of your values.
Without a correct relationship between the two tables, these values will always be repeated.
To help you here it would be nice if you would give us sample tables that show the structure of real tables.
So we could help you with data modeling and your problem.
Without your SampleData Input it would be just meaningless guessing
If this post was helpful may I ask you to mark it as solution and give it some kudos?
Have a nice day!
BR,
Josef