Forum Discussion
Aggregation manage issues
1. Do you have any direct query mode table in your model? If not then, can you please exaplain what is your expectaion from manage aggregations feature. "Manage aggregations" is used to improve the performance of a large direct query based semantic model. Please refer this document
https://learn.microsoft.com/en-us/power-bi/transform-model/aggregations-advanced
2. Error message indicates
"There is another aggregation with the same summary and detail table/column combination.
If you set an aggregation for a table, it is automatically hidden." is it the case? If not, can you check if the error goes away after selecting the detail table from the drop down?Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos.
Proud to be a Super User!
Thanks for your reply.
So the 'manage aggregations' menu is only available to fill in if there is a relation from a Direct Query table to a (aggregated) Import Table?. I am following a course and set up a relation between a fact table (import) towards a aggregated table (import) as an exersize.
Error message indicates
"There is another aggregation with the same summary and detail table/column combination.
If you set an aggregation for a table, it is automatically hidden.'' This is indeed the (translated) case of the error get. So now, if I go in the manage aggregations menu, the options in the drop downs for detail table and detail column stay grey and are not able to be selected.