Show count of a category in a dynamic top N model

[JimSales81]

Hello,

I successfully created a dynamic Top N model in Power BI using the following data

'Sales' Table

Salesperson	Units Sold	Region
Jim	20	West
Kelly	18	West
Roger	17	East
Pam	15	East
Sally	12	West
Tom	9	East
Mike	8	West
Joe	7	East
Steve	5	West
Lauren	3	East

1.) Created a table called 'TOPN Selection'

Top N

3

5

8

10

2.) Created a measure called Selected N=

Selected N = SELECTEDVALUE('TOPN Selection'[Top N])

3.) Created a Units Rank Calculated Column

Unit Rank = rankx(Sales, Sales[Units Sold], , DEsc)

4.) Created a slicer Control

Slicer Control = var SelectedTop=Selectedvalue('TopN Selection'[Top N])

Return

if(SELECTEDVALUE(Sales[Unit Rank])<=SelectedTop, 1, 0)

5.) Added the Slicer control as a filter and selected is 1

It works great.  But what i want to do is add a card visual that shows the count of  West Salespeople dependent on the Top N selection

So when Top 3 is Selected my Card visual will say 2 (Jim & Kelly)

When Top 5 is Selected it will say 3 (Jim, Kelly, & Sally)

When Top 8 is Selected it will say 4 (Jim, Kelly, Sally, & Mike)

When Top 10 is Selected it will say 5 (Jim, Kelly, Sally, Mike, & Steve)

I can't figure out the dax.  Please advise.

Thank you!

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

[JimSales81]

Jihwan_Kim,

THis is perfect.  Similarly how would i write a measure to get the Total Units sold by Salespeople in the west based on the top N selection.

So if 3 was selected the total units sold in the west would be 38 but if 5 was selected it would change to 50, etc.

[Jihwan_Kim]

Hi,

thank you for your message, and please check the attached pbix file.