Relationship/Slicer Issue

Hi Vinicius_Buba,

The problem here is that when you disable visual interactions the table loses ALL filtering from the slicers So we need to manually recreate the filtering logic in DAX ☺️❤️

Could you please try these approaches: (Corrected)

First create and Use the Bridge Table Properly:

ANC_Relationships = 
SUMMARIZE(
    sch_fact_material_availability_global,
    sch_dim_anc_global[anc_code_old],
    sch_dim_family_global[sub_group],
    sch_dim_family_global[family]
)

Now create relationships:

• ANC_Relationships[anc_code_old] → sch_dim_anc_global[anc_code_old]

• ANC_Relationships[sub_group] → sch_dim_family_global[sub_group]

• ANC_Relationships[family] → sch_dim_family_global[family]

Then Create the Proper Filter Measure:

Filtered Quantity = 
VAR SelectedSubGroups = VALUES(sch_dim_family_global[sub_group])
VAR SelectedFamilies = VALUES(sch_dim_family_global[family])

// Get ANCs from selected subgroups/families using the bridge table
VAR RelevantANCs =
    CALCULATETABLE(
        VALUES(ANC_Relationships[anc_code_old]),
        ANC_Relationships[sub_group] IN SelectedSubGroups,
        ANC_Relationships[family] IN SelectedFamilies
    )

// Now get ALL subgroups/families that use these ANCs
VAR RelatedSubGroupsFamilies =
    CALCULATETABLE(
        SUMMARIZE(
            ANC_Relationships,
            ANC_Relationships[sub_group],
            ANC_Relationships[family]
        ),
        ANC_Relationships[anc_code_old] IN RelevantANCs
    )

// Check if current row exists in the related data
VAR CurrentSubGroup = SELECTEDVALUE(sch_dim_family_global[sub_group])
VAR CurrentFamily = SELECTEDVALUE(sch_dim_family_global[family])
VAR ShouldShowData =
    CONTAINSROW(
        RelatedSubGroupsFamilies,
        CurrentSubGroup,
        CurrentFamily
    )

RETURN
IF(
    ShouldShowData,
    SUM(sch_fact_material_availability_global[quantity]),
    BLANK()
)

If the bridge table approach is too complex, try this direct method (No Bridge Table):

Filtered Quantity Direct = 
VAR SelectedSubGroups = ALLSELECTED(sch_dim_family_global[sub_group])
VAR SelectedFamilies = ALLSELECTED(sch_dim_family_global[family])

// Get ANCs from current selection
VAR SelectedANCs =
    CALCULATETABLE(
        VALUES(sch_dim_anc_global[anc_code_old]),
        sch_dim_family_global[sub_group] IN SelectedSubGroups,
        sch_dim_family_global[family] IN SelectedFamilies
    )

// Use these ANCs to filter the entire table
RETURN
CALCULATE(
    SUM(sch_fact_material_availability_global[quantity]),
    KEEPFILTERS(sch_dim_anc_global[anc_code_old] IN SelectedANCs)
)

Note:

• Disable ALL visual interactions between slicers and your data table

• In your table visual use the Filtered Quantity measure as your value

• Keep your slicers as they are

You Can try the direct method (No Bridge Table) as it the simplest way it will work 😅❤️

Are you certain that the 2 ANCs you selected actually have values for the months in question? 

I partially understand the reason for the different behaviour between when you choose the 2 options individually and when you use the select all feature. Using select all means that no filters are generated from that slicer, rather than using the individual values as filters as happens when you select the items.

Do you have interactions turned off between the other slicers and the table visual ? I would have expected the selections in the other slicers to affect the list of ANCs returned by the VALUES clause in the TREATAS.