DAX Query

Hi TRPBI ,

According to your description, here’s my solution.

1.Create a table, there’s no relationship between the two tables.

2.Create a measure.

Result =

SWITCH (

    SELECTEDVALUE ( 'Table (2)'[Type] ),

    "A",

        CALCULATE (

            SUM ( 'Table'[Value] ),

            FILTER ( 'Table', [Tag] IN { "AB", "A", "ABC" } )

        ),

    "B",

        CALCULATE (

            SUM ( 'Table'[Value] ),

            FILTER ( 'Table', [Tag] IN { "AB", "ABC", "BC", "B" } )

        ),

    "C",

        CALCULATE (

            SUM ( 'Table'[Value] ),

            FILTER ( 'Table', [Tag] IN { "ABC", "BC" } )

        )

)

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.