Combined Aggregation Model

[danl5055]

Hi,

I'm trying to do something similar that is outlined in the documentation below but am seeing different results.  I am getting an error that states "Detail column cannot be aggregated to one or more Group By Columns using strong relationship".  It doesn't seem like my agg table is any more complex than the documentation and was wondering if this is a known bug.

https://learn.microsoft.com/en-us/power-bi/transform-model/aggregations-advanced#combined-aggregatio...

Thanks

[TomMartens]

Hey @danl5055 ,

create a pbix file containing sample data that still reflects your semantic model (tables, relationships, calculated columns, and measures), upload the file to OneDrive, Google Drive, or Dropbox and share the file. If you are using a spreadsheet to load the sample data, instead of using the manual input method, share the spreadsheet as well.

Your question does not contain any specifics of your environment or model, the topic of aggregations is not a simple one, even if aggregations can be simply configured. For this reason it's difficult to provide any ideas what is causing the error message, at least I'm not smart/experienced enough to provide guidance.

Take the time, prepare sample data, and share the pbix.

Regards,

Tom