Forum Discussion
ALLSELECTED
// 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.