Exclude what is selected on the slicer

[Anonymous]

Afternoon,

I have two tables that provide the same information. However, when I selected a value in the slicer , I want one table to show all infor for what the slicer has selected and the other to show everything except what has been selected on the slicer.

E.g.

Table 1: info for insurer selected

Table 2: Info for all other insurers except what is selected in slicer

Can anyone help me with this issue please?

[amitchandak]

@Anonymous ,

measure =

var _tab = except( all(Slicer[Slicer])  ,allselected(Slicer[Slicer]) )

return

calculate(sum(Table[Value]), filter(all(Slicer), Slicer[Slicer] in _tab))

when slicer is join to table. But these thing work best when it not joined

not selected measure =
var _tab = except( all(Slicer[Slicer]) ,allselected(Slicer[Slicer]) )
return
calculate(sum(Table[Value]), filter(Table, Table[Slicer] in _tab))

selected measure =
var _tab = allselected(Slicer[Slicer])
return
calculate(sum(Table[Value]), filter(Table, Table[Slicer] in _tab))