Forum Discussion

MeghnaZutshi's avatar
MeghnaZutshi
Frequent Visitor
3 years ago
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...
Need Help
  • MohammadLoran25's avatar
    MohammadLoran25
    3 years ago

    MeghnaZutshi ,

     

    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

MeghnaZutshi's avatar
MeghnaZutshi
Frequent Visitor
3 years ago

MohammadLoran25 
Not able to upload file here. here are my measures:

 

TopN_SelectedValue =

VAR SelectedTop= SELECTEDVALUE('Top N'[Top N])
RETURN

switch(TRUE(),
SelectedTop=0,[salesTotal],

Rankx(
    ALLSELECTED('Sales_data'[Sales Person]),
    [salesTotal]
)<=SelectedTop,
[salesTotal]

)
Top N'[Top N] is the parameter name
 
I want a solution like this but without using TopN in filter pane:

 

It should show region as well which is there in the legends

MohammadLoran25's avatar
MohammadLoran25
Solution Sage
3 years ago

MeghnaZutshi ,

 

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

  • MeghnaZutshi's avatar
    MeghnaZutshi
    Frequent Visitor
    3 years ago

    Hi MohammadLoran25 

    It worked as expected.
    Thank you so very much!!