Forum Discussion
Aggregated column values disappear from visual
If I add fields or columns from a different table to the Power BI visual,
few columns that were already added in that visual, that were in summarized (avg, sum, count) format tend to disappear.
Other columns that were not summarized remain unaffected
In fact, I think these aggregate features work as expected. The default aggregated features are used to summarize value based on category(the category fields mean axis, legends, and 'do not summarized' fields that are in the visuals).
If you add more fields to your visuals without aggregate, they obviously will affect the current aggregate, and try to change the new effect to summary value include all existing categories.
In addition, you can refer to the following links if helps:
User-defined aggregations - Power BI | Microsoft Learn
Work with aggregates (sum, average, and so on) in Power BI - Power BI | Microsoft Learn
Row Context and Filter Context in DAX - SQLBI
Regards,
Xiaoxin Sheng
2 Replies
In fact, I think these aggregate features work as expected. The default aggregated features are used to summarize value based on category(the category fields mean axis, legends, and 'do not summarized' fields that are in the visuals).
If you add more fields to your visuals without aggregate, they obviously will affect the current aggregate, and try to change the new effect to summary value include all existing categories.
In addition, you can refer to the following links if helps:
User-defined aggregations - Power BI | Microsoft Learn
Work with aggregates (sum, average, and so on) in Power BI - Power BI | Microsoft Learn
Row Context and Filter Context in DAX - SQLBI
Regards,
Xiaoxin ShengRushikesh_2022
Sorry I'm not able to understand your question please provide more information. However I would advise you to use explicit measures which is always the best practice.
