Forum Discussion

jamienourish's avatar
jamienourish
Frequent Visitor
8 years ago
Solved

Help with relationships

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 

 

 

relations ship

Need Help
  • prateekraina's avatar
    prateekraina
    8 years ago

    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

2 Replies