Forum Discussion
Solved
Performance issue with AVERAGEX
I have a about 1.1 million rows of data with 7 columns. I tried this measure called "Average" to filter my visual, PBI visual is having a big performance/memory issue. Below is detail of that...
JustinDoh1 Instead of using VALUES, you can use SUMMARIZE to create a summarized table that might perform better.
Average =
AVERAGEX(
FILTER(
SUMMARIZE(
'TblCensus',
DimDate[DateFormat],
"ClientD_M1", [ClientD_M1]
),
[ClientD_M1] > 0
),
[ClientD_M1]
)
JustinDoh1 Instead of using VALUES, you can use SUMMARIZE to create a summarized table that might perform better.
Average =
AVERAGEX(
FILTER(
SUMMARIZE(
'TblCensus',
DimDate[DateFormat],
"ClientD_M1", [ClientD_M1]
),
[ClientD_M1] > 0
),
[ClientD_M1]
)
bhanu_gautam I have a question. I am experimeting with performance. It appears that when I try the same query in Bookmark, it is really slow or even it crashes. It says "There's not enough memory to complete this operation." Why is that?