Aggregated column values disappear from visual

[Rushikesh_2022]

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

[Anonymous · Accepted solution]

H @Rushikesh_2022,

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

[Fowmy]

@Rushikesh_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.