Top N filter using parameter

[DPJay]

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.

[v-yulgu-msft · Accepted solution]

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

[Anonymous]

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

---

[DPJay]

Thanks Yuliana..It worked

[RoboticPea]

Hi! 

This youtube channel helped me a lot and this may be the video you are searching for: https://www.youtube.com/watch?v=SsZseKOgrWQ&index=10&list=PLDz00l_jz6zym_YP8ZW11o52niGfCP8pN 

Hope it helps! 🙂