only choose the top 15% clients in slicer

[Anonymous]

I have a slicer with the names from our clients, but I only want to show the top 15% of our clients in the slicer.

The top 15% clients are the clients with the maximum turnover summarized over the last 4 years (2014 - 2015 -2016 -2017)

I have a table "alle afleveringen" with columns:

- name client

- turnover by invoice

- invoicenumber

- year

- month

[v-sihou-msft · Accepted solution]

@Anonymous

Currenly, we only have build-in "TOP N" filter, it doesn't have "TOP N percentage" filter. 

For your requirement, you need to create a RANK measure for all customers like: 

=RANKX(ALLSELECTED(Table[client]),SUM(Table[turnover by invoice]),,DESC)

Then use this measure to divide by all selected clients: 

TOP N Pct = RANKX(ALLSELECTED(Table[client]),SUM(Table[turnover by invoice]),,DESC)/COUNTA(Table[client])

Then use above measure as Visual Level Filter to make it less than 0.15.

Regards,