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
I still get the same error when trying to relate them.
What I did:
I cleaned the owning office so that it's now the same values.
In the owning office assigment I only deselected a couple of coulumns which as irrelevant for the report. Still it should work shouldn't it?
Here are the values now:
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