How to create bucket range to exclude the selected values

[Anonymous]

Hi

I have community count column, this column contains integer numbers. Here i have to create a bucket filter, that filter contains values as >10,>20,>30...>100. To acheive this i have tried below methods but its not working as i am expected. 

Required Output:

If I selected >10 value in filter it should be show values from 11 to max value and exclude the values(1 to 10) from grid similarlly if select for value as >20.

BucketRange =

 SWITCH (

  true(),

 Query1[CommunityCount] >10 && Query1[CommunityCount] <= Query1[MaxCount], ">10",

 Query1[CommunityCount] >20 && Query1[CommunityCount] <= Query1[MaxCount], ">20",

 "other"

--)

(OR)

 if(Query1[CommunityCount]>10 && Query1[CommunityCount] <= Query1[MaxCount],">10",if(Query1[CommunityCount] >20 && Query1[CommunityCount] <= Query1[MaxCount], ">20")))

Thanks in advance. 

Regards,

Yuvaraj

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

One sample for your reference. Please check the following steps as below.

1. Create a calculated column in the filter table and format it to number.

Column = RIGHT('filter'[bucket],LEN('filter'[bucket])-1)

2. Create a measure as below and make the table visual filtered by it as the picture.

Measure = var coun = MAX(Query1[community count])
var maxva = MAX('filter'[Column])
return
IF(coun>maxva,1,0)