Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Five Column Names = ParentID, ChildID, Column3, Column4, Column5
One ParentID can have multiple ChildIDs.
Two or more ParentIDs can have common Matching ChildIDs.
I have created one slicer using ParentID column. I need a DAX to fetch only matching (intersecting) ChildIDs for selected ParentIDs (it could be multiple ParentIDs selection) in slicer
Note: We need to have ParentID slicer in the report. Solution should take into account multiple selections in slicer.
Scenario 1:
Scenario 2 :
sorry, also just make sure the selected measure filters the visual to only show value of 1
Hi,
i have something that might work:
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!