Forum Discussion
Table Visual unable to load data despite having fewer rows.
Hi, I have two table visuals in a report on the same page in power bi desktop. I have applied pagination to both the tables with the display of items set to 25. Each table displays 25 items on each ...
Hi SaiK ,
try to update your DAX to look like bellow, this avoid using summirecolumnns twice and improve the perfomance:
DEFINE
VAR __FilteredTableB =
CALCULATETABLE(
'Table B',
TREATAS({"180 Days"}, 'slicer'[Values]),
TREATAS({25}, 'Items'[Items]),
TREATAS({1}, 'Pages'[Pages]),
'Table B'[Item Filter] = 1
)
VAR __DS0Core =
SUMMARIZE(
__FilteredTableB,
'Table B'[Column A],
"Measure A", 'Table B'[Measure A]
)
VAR __DS0PrimaryWindowed =
TOPN(501, __DS0Core, [Measure A], DESC, 'Table B'[Column A], ASC)
EVALUATE
__DS0PrimaryWindowed
ORDER BY
[Measure A] DESC, 'Table B'[Column A] ASC
Query (8, 13) A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.
Got this error
Sorry about that, use filter instead:
DEFINE VAR __FilteredTableB = CALCULATETABLE( 'Table B', TREATAS({"180 Days"}, 'slicer'[Values]), TREATAS({25}, 'Items'[Items]), TREATAS({1}, 'Pages'[Pages]), FILTER('Table B', 'Table B'[Item Filter] = 1) // ✅ Fixed filter ) VAR __DS0Core = SUMMARIZE( __FilteredTableB, 'Table B'[Column A], "Measure A", 'Table B'[Measure A] ) VAR __DS0PrimaryWindowed = TOPN(501, __DS0Core, [Measure A], DESC, 'Table B'[Column A], ASC) EVALUATE __DS0PrimaryWindowed ORDER BY [Measure A] DESC, 'Table B'[Column A] ASCResource Governing: This query uses more memory than the configured limit. The query — or calculations referenced by it — might be too memory-intensive to run. Either reach out to your Analysis Services server administrator to increase the per-query memory limit or optimize the query so it consumes less memory. More details: consumed memory 1024 MB, memory limit 1024 MB.