Forum Discussion

Anonymous

Not applicable

6 years ago

Relationships

Hi I'm really stuck on getting the relationships between tables to work. Here are my tables. The Calendar (months) doesnt seem to be working when i use the "count" measure in DimPlayer table...

Anonymous

Not applicable

6 years ago

Hi

DimPlayer cant work with Calendar because filter direction dont allow it. In your case if you choose date for calendar is only work for values in Fact and doesnt for Dim. You can change filter direction to both, all is there:

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

Anonymous
Not applicable
6 years ago
Thank you so much for your help!!

It works now on "both" :)

Much appreciated Walter.
- Anonymous
  Not applicable
  6 years ago
  Actually, i spoke to soon. It solved some problems, players by table seems to work (Fact and DimTable).
  But i'm still getting repeated numbers when pulling from revenue by table, using dimtable and calander month.
  
  Should they all be set to "both" like so?
  
  Thanks!
  - Anonymous
    Not applicable
    6 years ago
    Okay so i made some changes. i now have:
    
    1) Many to Many, both ways on each dim table, fact and calander. this seems to work fine with any data in the Fact Table. So thanks for that, that was an interesting read in the link above. However,
    
    2) I'm still unsure how to connect the Revenue table correctly, as this data doesnt come through (same number each month). I need this to work as if it were the FactTable.
    
    I'm at a loss and not sure what to do next, i feel like ive tried everything to no avail.
    
    Any help would be aweome.
    
    Thanks.