Forum Discussion
Amount clustered - Help needed
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.
))
Any suggestions?
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.