Forum Discussion

Chris_23's avatar
Chris_23
Helper II
3 years ago
Solved

Filter slicer based on table selection

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:
 
Any ideas what to improve?
 
Thanks
Chris
 
 

 

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

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