Forum Discussion
two filters with Ranks
Bimo , Try like
Rank>1 = rankx(FILTER(Table,Table[FirstDate]=EARLIER(Table[FirstDate]) && Table[ANALYST]<>"James"),[Sales],,DESC,Skip)
A column rank and sales should also be a column
if sales is a measure
Rank>1 = rankx(FILTER(allselected(Table),Table[FirstDate]=max(Table[FirstDate]) && Table[ANALYST]<>"James"),[Sales],,DESC,Skip)
Bimo , Try like
Rank>1 = rankx(FILTER(Table,Table[FirstDate]=EARLIER(Table[FirstDate]) && Table[ANALYST]<>"James"),[Sales],,DESC,Skip)
A column rank and sales should also be a column
if sales is a measure
Rank>1 = rankx(FILTER(allselected(Table),Table[FirstDate]=max(Table[FirstDate]) && Table[ANALYST]<>"James"),[Sales],,DESC,Skip)
great Thanks! it works well, I have now realised a second issue, if I filter by analyst it does not give me the top 20 for that analyst but what their records in the top 20, how can I fix that ? maybe something with ALLSELECT ?
I know that was not the original question but I can raise new post if that helps
Regards
