Remove rows matching slicer output

[Ianc33]

Hi Everyone,

I have a table which is similar to the below.

NAME, TAG

name1,tag1

name1,tag2

name2,tag1

name2,tag2

name3,tag1

name3,tag2

name4,tag1

Which is in a table visual.

If I was to slice the visual on tag2, i want another table visual that contains only name4 as it doesn't have tag2.

Is this possible?

Thanks in advance for your help.

[v-kelly-msft · Accepted solution]

Hi @Ianc33 ，

Duplicate the table;

Then create a measure as below:

Measure = 
var _namesexclude=CALCULATETABLE(VALUES('Table 2'[NAME]),FILTER(ALL('Table 2'),'Table 2'[TAG]=SELECTEDVALUE('Table'[TAG])))
var _nameremain=EXCEPT(DISTINCT('Table 2'[NAME]),_namesexclude)
Return
IF(ISFILTERED('Table'[TAG])=FALSE(),MAX('Table 2'[NAME]),IF(MAX('Table 2'[NAME]) in _nameremain,MAX('Table 2'[NAME]),BLANK()))

And you will see:

For the related .pbix file,pls see attached.

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@Ianc33 ,

You can get a table like

table = except(all(Table1[Tag]), allselected(Table1[Tag]))

or can get measure and add it visual

measure = count(countrows(Table), filter(all(table), not(Table1[Tag] in values(Table1[Tag]))))

[vanessafvg]

unless i misunderstand you you can filter your table visual with the filter on the right hand pane for that specific visual and also set your edit interactions to ignore any slicers on that visual.

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[Ianc33]

Hi Vanessafvg,

Thanks for taking the time to reply.

What I'm looking for is,

1 table visual that shows the matching data and a second that shows the non-matching data from the slicer