Forum Discussion

TCavins's avatar
TCavins
Icon for Helper V rankHelper V
6 years ago

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...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
TCavins
Icon for Helper V rankHelper V
6 years ago

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.