Getting repeated values with aggregation table

[swolfe2]

I have a data model where I have a DirectQuery fact table with close to a billion rows, and a user defined aggregation table that has ~300k rows.

When I attempt to do a simple SUM of a field, it's showing the same value for each row.

The fact table and aggregation table both have the same relationships configured

In DAX Studio, I can tell that it is successfully hitting the aggregation table:

The results from DAX Studio show the same values:

How can I get the individual values for each matching 'Calendar Latest Weeks'[Week Group Description] value? Before I implemented the aggregation table, even though queries took much longer, they did have different corresponding values:

Any help/advice would be greatly appreciated!

[TaylorPBI21]

What does your data model look like? I'd assume an incorrect/missing relationship somewhere. Your measure should be getting sliced by your Week Group Desc column in the table but it's not able to perform the filtering to give you the accurate sum's per Week Desc Group. 😎