Help with relationships

[jamienourish]

Morning, 

I am going to do my best to explain my problem, I have simplified the tables and removed data but wanted to show my relationships.

I am trying to create a table that has a list of level names and user locations. 

However due to the relationships I can't do this. I have been trying to create a measure to do a look up but get an extend list as it tries to give a location for each level for each user 

[prateekraina · Accepted solution]

Hi @jamienourish,

Created a calculated table from the DAX below and choose the columns from this table in your visual.

Location_Level =
SUMMARIZECOLUMNS (
    Location[LocationName],
    'Levels'[LevelName],
    "Default", SUM ( 'User Information'[UserID] )
)

Prateek Raina

[v-cherch-msft]

Hi @jamienourish

You may try to use SUMMARIZECOLUMNS Function. Here’s the reference for you.

https://www.sqlbi.com/articles/introducing-summarizecolumns/

Regards,

Cherie