encountering error with aggregation

[yves007]

I'm encountering an aggregation issue in Power BI. My main table contains columns for product descriptions, product numbers, reference periods, and month-to-month percent changes in product prices. The second table contains only product description numbers in a hierarchical structure.

I've connected the tables to create a column chart, allowing me to drill down into the data. However, I'm noticing that the values are aggregating instead of displaying distinct values.

I've checked the relationships, and they seem to be set up correctly as one-to-many. Additionally, I've verified that my measures are referencing columns from the main table. Despite this, I'm still experiencing aggregation of values.

Any insights or suggestions on how to troubleshoot and resolve this issue would be greatly appreciated

[PhilipTreacy]

Hi @yves007 

Hard to help without seeing your data or ideally your file to see what you have done.

Regards

Phil

[vicky_]

Most visuals (off the top of my head, only the regular table visual will allow you to not aggregate) will require you to aggregate the values somehow to display the data - this is just how it works. If you need distinct values, you need to make sure that each of your values will be distinct for the visible dimension(s) in the table.