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.

[sidhiq91]

@Aanchal  One small suggestion.

Use a Calculated Dimension as below:

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

[Color Priority])) <=10,[Color Priority]),[Color Priority])

And Measure would be:

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

If this resolves your issue, please like and accept it as a solution.

[Aanchal]

Hi , 

Thanks for the quick response . 

this is not limiting to 10 .

[sidhiq91]

@Aanchal  Could you please send me some sample data please?

[SunilChauhan]

Can we not achive this by Limiting  in Dimension

use formula without Rank i.e.

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

and limit dimension for  top 10 as in above screen shot.

See the example app also

[BrunPierre]

@Aanchal I concur with @SunilChauhan  on restricting the display values using dimension limits.

Alternatively, maybe this

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

[Aanchal]

This is a measure.

[Aanchal]

its showing only 1 as output 

[BrunPierre]

What is the expected output?

[Aanchal]

This is desired output , but i have to display only top 10  on basis of no. of instances. 

where my no. of instances is a set expression a measure 

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