Show rows based on selected filter in another column

Hi Rani301170 ,

 

To achieve this in Power BI, you can first create a disconnected slicer table using the formula Project Selector = DISTINCT('YourTable'[Project]). This table will serve as the slicer so that selecting a project doesn't directly filter your main table, giving you more control over the logic.

Next, create a calculated table that returns all the projects sharing the same Parent as the selected project, but only when the selected project is a Parent. Otherwise, it will simply return the selected project. Use the following DAX for the calculated table:

Filtered Projects = 
VAR SelectedProject = SELECTEDVALUE('Project Selector'[Project])
VAR SelectedParent =
    CALCULATE(
        MAX('YourTable'[Parent]),
        'YourTable'[Project] = SelectedProject
    )
VAR IsSelectedAParent =
    CALCULATE(
        COUNTROWS('YourTable'),
        'YourTable'[Parent] = SelectedProject
    ) > 0
RETURN
    IF(
        IsSelectedAParent,
        FILTER(
            'YourTable',
            'YourTable'[Parent] = SelectedProject
        ),
        FILTER(
            'YourTable',
            'YourTable'[Project] = SelectedProject
        )
    )

This logic ensures that if a user selects "bbb", which is a Parent, the table will return all projects where the Parent is "bbb" (like 1b, 2b, 3b, 4b). If the selected project isn't a Parent, it will just return that project itself. You can use this calculated table in your visual to display the desired filtered results.

 

Best regards,