Forum Discussion
ALLSELECTED
What kind of visual is it? Use Performance Analyzer to check the DAX query that feeds your visual. You can use that as the basis for your ranking measure.
// DAX Query
DEFINE
VAR __DS0FilterTable =
FILTER(
KEEPFILTERS(VALUES('plantedtrial'[plant_quantity])),
'plantedtrial'[plant_quantity] > 0
)
VAR __SQDS0Core =
SUMMARIZECOLUMNS(
'variety'[variety_name],
__DS0FilterTable,
"yieldplantquantity", 'yield_measures'[yieldplantquantity]
)
VAR __SQDS0BodyLimited =
TOPN(15, __SQDS0Core, [yieldplantquantity], 0)
VAR __DS0Core =
SUMMARIZECOLUMNS(
'variety'[variety_name],
__DS0FilterTable,
__SQDS0BodyLimited,
"sortr3", 'rankround_measures'[sortr3],
"eliminatedrank", 'rankround_measures'[eliminatedrank],
"rankround1", 'rankround_measures'[rankround1],
"rankround2", 'rankround_measures'[rankround2],
"rankround3", 'rankround_measures'[rankround3]
)
VAR __DS0PrimaryWindowed =
TOPN(1001, __DS0Core, [sortr3], 0, 'variety'[variety_name], 1)
EVALUATE
__DS0PrimaryWindowed
ORDER BY
[sortr3] DESC, 'variety'[variety_name]
here's the performance review and the visual is just the stacked bar chart
now take this query into DAX Studio and run it there after enabling Query Plan. Check for excessive number of records. See if you can isolate the performance of your individual rankround measures.