Forum Discussion

Mhorne's avatar
Mhorne
Frequent Visitor
8 years ago

TopN Misranking values.

TopN is miscalculating the ranking in my measure. 

 

I created a metric that allows a user to filter the table according to a selection they make. 

 

The measure calculates correctly when '4' is selected, but mis-ranks the values when '3' is selected. 

 

Any idea what might be causing this?

 

 

2 Replies

  • Mhorne's avatar
    Mhorne
    Frequent Visitor
    8 years ago

    Adding screenshots for help seeing the issue. 

     

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Mhorne,

     

    Can you share the file, please? You can mask the data first. At least provide something like below.

    1. What the formula of Rank?

    2. Where is the Selection from?

    3. What's the data structure?

     

    The possible cause could be the "Val-U" is excluded when you select 3.

     

    Best Regards,

    Dale