Slicer Visual - Group All members and All members excluding one of them

[NirH_at_BITeam]

Hi,

This may sounds Simple but I was not able to think of a way to implement that.

I have a short list of Vendors:

Vendor A

Vendor B

Vendor C

Vendor D

Vendor E

I would like my users to have a basic slicer (using the slicer visual) that will provide them with the following options:

SlicerName

 - "All Vendors Inc. Vendor E"

 - "All Vendors Exc. Vendor E"   

I put apostrophes because this is the naming convention I would like to use for my users.

The first one should include all members and the second one should include all except Vendor E.

I was trying to use Grouping but this ONLY allows to reaggregate my list of values and doesn't give the option to use ALL members along with a new group that is created.

Also the option of "Select All" in teh slicer format under "Selection Control" doesn't provide an adequate solution to my request.

Any idea how this can be resolved?

Sounds quite simple to me...

Thanks!

NH

[v-qiuyu-msft · Accepted solution]

Hi @NirH_at_BITeam,

You can add a new table which contains values: All Vendors Inc. Vendor E, All Vendors Exc. Vendor E. Then add this column to a slicer visual, create a measure: 

Measure = IF(MAX(Table2[Column1])="All Vendors Inc. Vendor E",SUM(Table1[Amount]),CALCULATE(SUM(Table1[Amount]),FILTER('Table1','Table1'[Category]<>"Vendor E")))

Best Regards,
Qiuyun Yu