Forum Discussion

Joe_Marangos's avatar
Joe_Marangos
Frequent Visitor
4 years ago
Solved

USERELATIONSHIP not working as expected. Could use some suggestions.

Hi all, Im working on a report that invovles interactive mapping. The complexity with the project is that there are different legends for different data layers which means I have to use a table to g...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi Joe_Marangos ,

    As the relationship only active in the measure calculation, NO2_Cat and NOX_Cat can't be filtered by the Legend_Table, they don't actually have a relationship.

    For your purpose, the data model should be modified or create a new table.

    Method1.

    In Power Query, unpivot the NO2_Cat and NOX_Cat columns.

    They'll be in one column, so it's easy to build relationships.

    Method2.

    Create a new table, separate NOX_Cat.

     

    NOX_Cat Table = SELECTCOLUMNS('Pollution_Data',"NOX_Cat",'Pollution_Data'[NOX_Cat])

     

    Both tables are related to Legend_Table.

    This is an overall idea, the specific operation should be combined with your sample.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Joe_Marangos ,

As the relationship only active in the measure calculation, NO2_Cat and NOX_Cat can't be filtered by the Legend_Table, they don't actually have a relationship.

For your purpose, the data model should be modified or create a new table.

Method1.

In Power Query, unpivot the NO2_Cat and NOX_Cat columns.

They'll be in one column, so it's easy to build relationships.

Method2.

Create a new table, separate NOX_Cat.

 

NOX_Cat Table = SELECTCOLUMNS('Pollution_Data',"NOX_Cat",'Pollution_Data'[NOX_Cat])

 

Both tables are related to Legend_Table.

This is an overall idea, the specific operation should be combined with your sample.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.