Custom filter buttons

Hi deepguptaac 

If you want to custom filter buttons, I think field parameter is suitable for you. Here's my sample.

My test table:

Create some measures of criteria you want to filter:

Without Item category A = CALCULATE(SUM('Table'[Sales]),FILTER('Table','Table'[Item category] <> "Item category A"))

Item category A & B = CALCULATE(SUM('Table'[Sales]),FILTER('Table','Table'[Item category] = "Item category A" || 'Table'[Item category] = "Item category B"))

Item category C = CALCULATE(SUM('Table'[Sales]),FILTER('Table','Table'[Item category] = "Item category C"))

Enable field parameters:

Create field parameters:

You will get a parameter table like this:

Then you can use the field paramter to create slicer to filter your report:

Best regards,

Yadong Fang

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