Forum Discussion
Relate one column to multiples
You can still count things when you ID link them with relationships. That's the premise of data modeling - if you want to be successful with Power BI, you have to use the dimensional modeling aspect of the tool. You can make a measure that counts the item IDs in the primary table and then drop in the strength value from the second table in the visual this way. If you have them unpivoted in the second table, that's totally fine - just make sure to keep the item ID in there for the relationship. People tend to use "unpivot other columns" to do this, where you leave just the item ID and the 4 strengths columns, select item ID, right click -> unpivot other columns option. That gets the strengths labels into a single column and leaves the ID for the relationship.
I don't totally follow, but if you have multivalue columns in SharePoint, the best way to maintain the relationships is to expand just the single multivalue field in a separate query table, leaving in the item ID, and then relate it back to your other table using relationships. Usually you need to set the relationship to bidirectional (both) when you do this to get the filters to flow in the right direction. This will let you count items by whatever the multivalue field was in charts - you use the strength field for example from that second table.