Forum Discussion
Solved
TopN
i have created the foolowing visual which shows the topN sales person based on the slicer value. But as soon as i put region in legends, it no longer shows me top 4 sales person overall but...
1-Create a meaasure:
SalesTotal = SUM(PersonRegionTable[sales])2-Create a rank measure:
RankMEasure = RANKX ( ALLSELECTED ( PersonRegionTable ), [SalesTotal] )3-Create a measure for your slicer value which is selected:
TOPNVALUE = SELECTEDVALUE(TOPNTABLE[VALUES])4-Create a measure as filter on the visual:
FILTERMeasure = IF ( [RankMEasure] <= [TOPNVALUE], 1, BLANK () )Then put the [FilterMeasure] on your Visual as Filter on this visual on FilterPane and set it equals to 1.
If this helps you, accept it as a solution.
Regards,
Loran
1-Create a meaasure:
SalesTotal = SUM(PersonRegionTable[sales])2-Create a rank measure:
RankMEasure =
RANKX ( ALLSELECTED ( PersonRegionTable ), [SalesTotal] )3-Create a measure for your slicer value which is selected:
TOPNVALUE = SELECTEDVALUE(TOPNTABLE[VALUES])4-Create a measure as filter on the visual:
FILTERMeasure =
IF ( [RankMEasure] <= [TOPNVALUE], 1, BLANK () )
Then put the [FilterMeasure] on your Visual as Filter on this visual on FilterPane and set it equals to 1.
If this helps you, accept it as a solution.
Regards,
Loran
Hi MohammadLoran25
It worked as expected.
Thank you so very much!!