Forum Discussion
Display Nth value
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
4 Replies
Hi TCavins ,
Check if this works for you:
If you consider it as a solution, please mark as a solution and kudos.
Ricardo
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-finaleVisual level filter
Use of what if
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
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.
