Forum Discussion

Rfranca's avatar
Rfranca
Resolver IV
7 years ago

TOPN dynamic

I am using the formula to create a table   TabelaRank =CALCULATETABLE(VALUES(Sales[Pagamento]);TOPN (1; ALLSELECTED(Sales[Pagamento]); [Asset Rank]; ASC ))   TOPN(<n_value>, <table>, <orderBy_exp...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Write the RANKX function instead and filter the result of the RANKX function with a crtieria of say <=3.

  • Rfranca's avatar
    Rfranca
    Resolver IV
    7 years ago

    Ashish_Mathur  

    thank you... but....

    the TOPN function in DAX the N_Value parameter does not work when the value comes from a measure, only accepts value typed.
    I want to use a dynamic value for this parameter that comes from a SLICER.

    How to make it happen?

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      7 years ago

      Hi,

      The N value in the TOPN() function can be the result of a measure.  Create a Table with 5 values (from 1 to 5).  Name that as Rank_values.  Create a slicer visual and drag the Values field from the Rank_values Table.  Select anyone value there.  Write this measure

      Selected Top N = MIN(Rank_values[Value])

      In your RANKX formula, the first inout should be [Selected Top N]

      Hope this helps.