Display Nth value

[TCavins]

I have a table displaying Person, Company and Number of Meetings. I have a measure that counts the number of meetings and that measure is in a filter so the table only displays people that have 10 or more meetings. The measure is a DISTINCTCOUNT on the Meeting Date. So in the table it displays the count for that person and that company.

Person, Company, Meeting Count

1, A, 15
2, B, 31

3, A, 14

etc

What I'd like to do is for those people that have 10 or more meetings is to also show the date of the 10th meeting in the table. I'm not sure how to go about getting that.

Sample Data

Person| Company | Meeting Date

1         | A              | 1/1/2001

1         | A             | 1/10/2001

2         | A              | 1/11/2001

2         | C              | 1/13/2001

3         | D              | 1/14/2001

4         | A              | 1/15/2001

[v-lili6-msft]

hi  @TCavins 

For show the date of the 10th meeting, create a measure as below:

10th meetingdate= IF(RANKX(FILTER(ALLSELECTED('Table'),'Table'[Person]=MAX('Table'[Person])),CALCULATE(MAX('Table'[Meeting Date])),,ASC)=2,CALCULATE(MAX('Table'[Meeting Date])))

Regards,

Lin

[TCavins]

Lin, when I add this to my table that already has Person, Company and a measure for number of meetings, the value is blank for every row.

[amitchandak]

@TCavins , Rank should help. You can use in a filter or use the visual level filter

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale

Visual level filter

https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...

Use of what if

https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

[camargos88]

Hi @TCavins ,

Check if this works for you:

If you consider it as a solution, please mark as a solution and kudos.

Ricardo