How to indirectly filter visual?

[maflingo]

Hi,

I have a visual that shows the Visits per Company. When I select a certain Company in a slicer, I want the visual to only show the copmanies that have the same value in the field Peer Group as the selected Company.

I've tried building measures with SELECTEDVALUE and editing the interactions of slicers and the visual, but the visual always just shows all the companies.
The fields Copmany, Visits and Peer Group are all from the same table Startups.

Does anybody know how this could be achieved? Thank you!

[Ashish_Mathur]

Hi,

I have solved a similar problem in the attached file.

Hope this helps.

[v-sgandrathi]

Hi @maflingo,

Thank you for using Microsoft Fabric Community and Thank you @pankajnamekar25 for your response.

May i know is your Issue Been Resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.

Thank you.

[v-sgandrathi]

Hi @maflingo,
we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-sgandrathi]

Hi @maflingo,

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[pankajnamekar25]

Hello @maflingo 

Add this measure to your visual.

FilteredVisits =

VAR SelectedPeerGroup = SELECTEDVALUE(Startups[Peer Group])

RETURN

CALCULATE(

    SUM(Startups[Visits]),

    FILTER(

        Startups,

        Startups[Peer Group] = SelectedPeerGroup

    )

)

Ensure the slicer is filtering only the Company field.

The measure will dynamically adjust the visual to show only companies in the same Peer Group as the selected one.

Thanks,
Pankaj

If this solution helps, please accept it and give a kudos, it would be greatly appreciated.