Forum Discussion

DPJay's avatar
DPJay
Regular Visitor
7 years ago
Solved

Top N filter using parameter

Hello,   I am trying to create a top N filter based on parameter. The parameter i have created is called Rank selection but i am not able to find a way to filter my table based on the parameter.  ...
Need Help
Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi DPJay,

     

    Once you created a What If parameter, a measure returns selected value will be generated automatically.

     

    Create an extra measure as below. 

    Measure = IF([RankMeasure]<=RankSelection[RankSelection Value],1,0)

    Add above new created measure into visual level filter.

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi DPJay,

 

Once you created a What If parameter, a measure returns selected value will be generated automatically.

 

Create an extra measure as below. 

Measure = IF([RankMeasure]<=RankSelection[RankSelection Value],1,0)

Add above new created measure into visual level filter.

 

Best regards,

Yuliana Gu

  • DPJay's avatar
    DPJay
    Regular Visitor
    7 years ago

    Thanks Yuliana..It worked :smileyhappy:

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    hi

     

    i am getting some  issue implementing this

    v-yulgu-msft wrote:

    Hi DPJay,

     

    Once you created a What If parameter, a measure returns selected value will be generated automatically.

     

    Create an extra measure as below. 

    Measure = IF([RankMeasure]<=RankSelection[RankSelection Value],1,0)

    Add above new created measure into visual level filter.

     

    Best regards,

    Yuliana Gu