Amount clustered - Help needed

[omelei86]

Hi 

My table looks as follows:

Id	Amount
1	12
2	16
3	1
4	4
5	26
6	45
7	99

I'd like to add some clusters as a filter 

0 < 25

25 < 50

50 < 100

I tried an IF statement but somehow my filter does not work. 

MEASURE =

IF(table,table[column]) < 25,"< € 25",

IF(table,table[column]) < 50," € 25 < € 50",

"< € 100"
))

Any suggestions?

[Anonymous · Accepted solution]

Hi @omelei86 ,

Power BI doesn't support us to add a measure in Slicer. I suggest you to create a cluster calculated column by dax and create a slicer by this column.

Cluster = 
IF('Table'[Amount]<25,"€ 0 < € 25",IF('Table'[Amount]<50,"€ 25 < € 50","€ 50 < € 100"))

Result is as below.

You may refer to below blogs for more details about the differences between measure and calculated column.

For reference:

 What is the difference between Power BI calculated columns and measures?

Power BI Measures vs Calculated Columns

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.