Forum Discussion

JackWren's avatar
JackWren
Icon for Helper II rankHelper II
4 years ago

Top10 and bottom10 values within the same table - Improving performance

Hi everyone, 

 

I trying to make it so that the end user can display the top 10 or bottom 10 customers within the same table, based on the measure Moving Difference2 . 

 

It's giving me results but it's rather slow so, I was wondering has anyone ever tried something like that? 

 

I'd rather avoid using bookmarks if I could but it might be best performance-wise. 

 

 

My table that I used to know how to sort the data. 

 

The measure :

 

TopOrBottom10 Customers =
Var SelectedTB = SELECTEDVALUE(AscOrDesc[Key])
Var Bottom =
If([Moving Difference2]=0,
blank(),
rankx(
filter(
all('Customer Portfolio'[CUSTOMER]),
[Moving Difference2]<>blank()),
[Moving Difference2],,
asc,
Dense
))
 
Var Top1 =
if([Moving Difference2]=0,
blank(),
rankx(
Filter(
all('Customer Portfolio'[CUSTOMER]),
[Moving Difference2]<>blank()),
[Moving Difference2],,
desc,
Dense
))
 
Var MovingDiffAsc = if(bottom<=10,[Moving Difference2])
Var MovingDiffDesc = if(Top1<=10,[Moving Difference2])

RETURN

Switch(
True(),
SelectedTB=0,MovingDiffAsc,
SelectedTB=1,MovingDiffDesc,
[Moving Difference2]
)
 
Thank you 
 
Jack

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    "based on the measure Moving Difference2" 

     

    Please show the measure.

    • JackWren's avatar
      JackWren
      Icon for Helper II rankHelper II
      4 years ago

      I used another way finally because my dataset is too big and the measure was probably too complex.