Filter a matrix by a slicer and show all data with common group value

[Chris_23]

Hi,

i am working on the following problem: Put a selection on a slicer and show all projects where the selected vendor is listed:

I've tried to work with a measure and include them into the matrix filter criteria --> show all values, wich are not blank

Measure 'take it into account':

CALCULATE(countrows(distinct(ALLSELECTED('Table'))), ALL('Table'[Vendor]))

But it doesn't work so far. So is there any possibility to exceed the single selection of the slicer and show the value of the group.

PBI Example:

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

Many thanks

Chris

[Chris_23]

thanks a lot

[amitchandak · Accepted solution]

@Chris_23 , Have slicer on an independent vendor table

Then Create a measure

=

var _vendor = summarize(Filter(Table, Table[Vendor] in values(Vendor[Vendor]) ), Table[Project])

return

calculate([measure], filter(Table, Table[project] in _vendor) )