Forum Discussion
Hitting Agg Table with Disconnected Table
Dear experts, I am using a direct query connection to a fact table that has 5 dimensions. I have successfully set up an aggregation table. The aggregation table sums the output of the fact...
Hi dd2909 ,
The documentation describes the Agg table model with non-dependent relations:
User-defined aggregations - Aggregation based on GroupBy columns
And try rewriting the LOOKUPVALUE() part of the code using TREATAS() to see if you can hit the Agg table.
TREATAS – DAX Guide
Propagating filters using TREATAS in DAX - SQLBI
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group