TOPN how to show in report

[sadath]

Hi

i have managed to get the top 15 stores from this formula
TopStore:=SUMX(
TOPN(15,
SUMMARIZE(
STORELIST,
STORELIST[PARLOUR],
"Tot Unit"
,calculate(Sum(SALESACTUAL2017[QTY]),FILTER(PLU,plu[PLU]=483||plu[PLU]=484||plu[PLU]=485||plu[PLU]=486))),[Tot Unit],0),[Tot Unit])

When i drag the TopStore measure in value field, i get correct result
but when the store names add to row filter value showing for all stores (like total of all stores, instead of 15 stores)
how can i show only the 15 store list and their total

 

[gazpage]

Not super clear what you are after here. Does the TOPN filter meet you needs?

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/#analytics

Otherwise I would think you would want to filter your table down as part of the measure.