Filter visual based on slicer selection

[jja]

Hi

I have this schema:

I have a slicer Type that is a column from Components table

When selecting one of the values in this slicer i want to calculate and filter(in Donut chart visual) how many projects have  customers based on this slicer seletected value

IF i make relationship bidirectional between components and projects i can achieve this but i know bidirectional relationships are evil so i want to use visual level filters but i can't figure it out how to do that.

Can you please help

[v-janeyg-msft · Accepted solution]

Hi, @jja 

You can create a measure and use it in visual.

Like this:

Measure = COUNTX(filter(ALL(projects),[projectID] in DISTINCT(components[projectID])),[CustomerID])
//COUNTX(filter(ALL(projects),[projectID] in DISTINCT(components[projectID])),[projectID])

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey