Help with slicer/table visual and contexts

Hi RamEHG ,

To achieve the desired output, you need a measure that correctly filters the company based on the selected person and counts the discussions accordingly. Since Table2 and Table3 have a many-to-many relationship, you must ensure that the filter context propagates properly. The approach involves capturing the selected person's company, filtering Table3 based on that company, and then counting the number of discussions for each person in that company from Table1.

The following DAX measure accomplishes this:

Count of Discussions = 
VAR SelectedCompany = 
    SELECTEDVALUE(Table2[CompanyName]) 

RETURN
    CALCULATE(
        COUNT(Table1[UniqueID]),
        FILTER(
            Table3, 
            Table3[CompNew] = SelectedCompany
        )
    )

This measure works by first retrieving the company associated with the selected person in Table2 using SELECTEDVALUE(Table2[CompanyName]). Then, it applies a filter on Table3 to only include rows where the company matches the selected company. Finally, COUNT(Table1[UniqueID]) calculates the number of discussions for people within that company.

For example, when John is selected in the slicer, the table visual will display John and Per1 under Company Comp2 with discussion counts of 2 and 1, respectively. Similarly, if Ram is selected, the table will show Ram and Per2 under Company Comp1 with discussion counts of 2 and 0.

To ensure the relationships work correctly, they must be active, and the filtering logic in the measure must be applied correctly. If multiple people are selected in the slicer, SELECTEDVALUE returns BLANK(), so adjustments using VALUES(Table2[CompanyName]) may be needed for multi-selection scenarios. If Table3 does not filter properly, wrapping it with ALL(Table3) inside the FILTER function might help.

Best regards,