Table - Don't summarize - Identify which Values

[AvPowerBI]

Hi,

I have a table with quite a lot of Values on it, is there a way to identify which Values are using the Don't summarize or is there a way to set all the values to be Don't summarize, as look like any values that is using one of the Aggregation functions is causing perfomance issues but it taking a biit of time identify which one it is and is really slow.

Would DAX Studio, ALM Toolket, Tabular Editor be able to do this?

Thanks

[amitchandak · Accepted solution]

@AvPowerBI , In the data model view, open properties, Select multiple columns/measure and under the advance property you have an option summarized by , use that

[MFelix]

Hi @AvPowerBI,

Using DAX Studio can help you achieve the necessary information check links below:

https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/

https://powerbi.tips/2020/06/model-performance-in-dax-studio/

(this last one has more videos related)