Filter by Measure Amount (1k, 5k, 10k...)

[pbrainard]

I have a list of Donor Names and I want to be able to have a slicer that shows Donors that donated up to $1k, between 1k and 5k, 5k to 10k, etc.) I don't know where to start! 

[Anonymous · Accepted solution]

Hi @pbrainard ,

Please try the measure and apply it as a visual-level filter.

Measure = 
VAR _sum =
    SUM ( 'Table'[Amount] )
VAR range =
    SWITCH (
        TRUE (),
        _sum < 1000, "< 1k",
        _sum < 5000, "1k - 5k",
        _sum < 10000, "5k - 10k",
        ">= 10k"
    )
RETURN
    COUNTROWS ( FILTER ( 'Table', range IN VALUES ( Slicer[Range] ) ) )

My PBIX file: Filter by Measure Amount.pbix

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pbrainard]

Thank you, this works great!!

[grantsamborn]

Another method (if you add Upper and Lower columns to your slicer table):

Measure_2 = 
CALCULATE(
    COUNTROWS('Table'),
    FILTER(
        'Table',
        'Table'[Amount] > MIN('Range'[Lower])
            && 'Table'[Amount] <= MAX('Range'[Upper])
    )
)

If you add another category to your slicer table, this method won't require any changes.

[littlemojopuppy]

Hi @pbrainard 

Do you have some sample data to play with?