Relationship issue in composite models

[Kolumam]

Hi All,

I was trying to use composite models. In my case I need to create a relationship between StationID of one table and Reference of other table. The station Id has the same value for all the columns whereas the reference has different values but only one value matches with the stationID. Power BI assumes this as many-many and creates it but when I try to mix fields to create visuals it says relationship is not established. Please help.

[v-chuncz-msft · Accepted solution]

@Kolumam,

You may adjust Aggregates (sum, average, maximum, etc.) in Power BI.