Filter slicer based on table selection

[Chris_23]

Hi,

i need to filter back to a slicer based on the selection of a table. There are two identically datasets:

On the report, i want to get all classification which are in filter contex of Table[Vendor]

I tried to set following measure in the 'filtercriteria for slicer':

Filterback = CALCULATE(COUNTROWS(Distinct('Table (2)'[classification])),USERELATIONSHIP('Table (2)'[Vendor],'Table'[Vendor]), Filter('Table (2)', 'Table (2)'[classification]= "P1"|| 'Table (2)'[classification]= "P2" ||'Table (2)'[classification] = "P3"))

Link to pbix:

https://1drv.ms/u/s!AsLM3f2rQCP34xv34CARLr8vZ0bv?e=WDGP6j

Any ideas what to improve?

Thanks

Chris

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[lbendlin]

It's not clear to me what you are trying to achieve. The tables are (inactively) joined via Vendor, not via classification.