How to achieve a data model where everyhting can be filtered according to data

[Matthias93]

Hi I have a question regarding my data model (found in the link at the bottom of the message)

I have a table with members that is connected to performance snapshots. These are represented by the following tables:

1. Performance Snapshot
2. PS CC
3. PS FC

Each of these tables is connected to a member in my member table and a date in my data table. Each of those tables is also connected to a summary table where i calculate an average score. However I'm not allowed to make the relationship between these 3 tables and my data table in both directions. The result is that when I filter a visual to a date selection, it will apply to those 3 tables above, but not the summary table since the calculation is just made on all the data is the tables instead of just the date selection. Has anyone got an idea on how I could model this so that everything is filtered to date when changing the date selection?

https://photos.app.goo.gl/lK2lNPkltdoN0F6y1

Thanks in advance for your help

Best regards,

Matthias

[v-chuncz-msft · Accepted solution]

@Matthias93,

Values in a calculated table are fixed. You'll need to create a measure.