Ignoring a particular item in slicer on a table visual

[Anonymous]

I have a slicer with 4 items. Eg: x,y,z,and o.

Requirements:

1. If I select O ,the table visual should display everything as if x,y and z  selected.If any item other than O is selected, visual should display only values correspondng to single selection.Is it possible to ignore only one selection? x->x,y->y,z->z,O->x+y+z
2. The slicer should behave normally for all other visuals in the same page.

       How can I accomplish this?

[Anonymous]

I can't use another table as slicer in this case. The slicer should behave normally with all other visuals except the table.

[v-deddai1-msft]

Hi @Anonymous ,

The normal solution for your case is creating a disconnected table with these slicer value as mentioned by amitchandak.

The detailed solution depends on your data model. Would you please show us sample pbix file, Then there may be a solution to your case.

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

Best Regards,

Dedmon Dai

[Anonymous]

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

You can use visual level filter:

Measure = IF(ISFILTERED(Table2[category]),IF(MAX(Table2[category])="o",1,IF(MAX(Table2[category])= MAX(Table1[Category]),1,0)),1)

Please refer to the pbix file.

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

Best Regards,

Dedmon Dai

[Anonymous]

Thanks.. It worked

[amitchandak]

@Anonymous , prefer an independent table for these values. Then you can have a measure like 

measure =

var _val = selectedvalue(Dim[Col])

return

if(_val = "o", calculate(sum(Table[Value]), filter(Table, Table[Col] <> _val)) , calculate(sum(Table[Value]), filter(Table, Table[Col] = _val)))