Forum Discussion

swolfe2's avatar
swolfe2
Icon for Helper I rankHelper I
3 years ago

Getting repeated values with aggregation table

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'...
Need Help
Need Help DAX
TaylorPBI21's avatar
TaylorPBI21
Icon for Resolver I rankResolver I
3 years ago

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. 😎