Limit top 10 By measure (Set Expression)

[Aanchal]

Dear , 

This is my set Expression

=count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority])

for total no. of colour instances   i have to show top 10 . 

i used this expression 

=Aggr(Rank(count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority])) <=10,[Color Priority])

Its not working . Please Suggest.

[SunilChauhan]

Have you tried this?

IF(Aggr(Rank(count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority])),[SKU Code],[Color Priority]) <=10,count({<[Date Stamp] ={">=$(=Date(Today()-90,'DD-MM-YYYY'))<=$(=Date(today(),'DD-MM-YYYY'))"}>}[Color Priority]))

[Aanchal]

Yes , this is not limiting to top 10 .

[BrunPierre]

@Aanchal  Try this

IF(RANK( Count(Aggr(Count([Color Priority])),[SKU Code]))<=10,Count([Color Priority]))

[Aanchal]

[BrunPierre]

This instead

IF(RANK(Count(aggr(Count([Color Priority]),[SKU Code],[Color Priority])))<=10,Count([Color Priority]))

[Aanchal]

No, not working.