Creating Measures that take context from multiple slicers based on same dimension

Hi Sparks ,

Would you please follow the following steps?

1.Create two calculated table for the Major slicer and the Minor slicer:

Majorslicer = CALCULATETABLE(VALUES('Area of Study'[Area of Study Name]), FILTER('Area of Study','Area of Study'[Type] = "Major"))



Minorslicer = CALCULATETABLE(VALUES('Area of Study'[Area of Study Name]), FILTER('Area of Study','Area of Study'[Type] = "Minor"))

2.Create a measure for filter the table visual:

Measure =

VAR a =

CALCULATETABLE (

VALUES ( CourseList[CourseSK] ),

FILTER (

ALL(CourseList),

RELATED ( 'Area of Study'[Area of Study Name] )

= SELECTEDVALUE ( Majorslicer[Area of Study Name] )

)

)

VAR b =

CALCULATETABLE (

VALUES ( CourseList[CourseSK] ),

FILTER (

ALL(CourseList),

RELATED ( 'Area of Study'[Area of Study Name] )

= SELECTEDVALUE ( Minorslicer[Area of Study Name] )

)

)

RETURN

IF ( MAX ( Courses[CourseSK] ) IN a || MAX ( Courses[CourseSK] ) IN b, 1, 0 )

And put the measure in table visual filter:

For the dax code modification of your other measures, please refer to the pbix file: https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EWJvRXHiHDhCnz2MYRgm05gBTDy7fl7pHG2muAzQtShzaA?e=LV3eS2

Best Regards,

Dedmon Dai

You can modify the measure as below:

FlagShowCourse =
VAR a =
    CALCULATETABLE (
        VALUES ( CourseList[CourseSK] ),
        FILTER (
            ALL ( CourseList ),
            RELATED ( 'Area of Study'[Area of Study Name] )
                IN VALUES ( Majorslicer[Area of Study Name] )
        )
    )
VAR b =
    CALCULATETABLE (
        VALUES ( CourseList[CourseSK] ),
        FILTER (
            ALL ( CourseList ),
            RELATED ( 'Area of Study'[Area of Study Name] )
                IN VALUES ( Minorslicer[Area of Study Name] )
        )
    )
VAR SelectedMajorCount =
    IF (
        NOT ISFILTERED ( Majorslicer[Area of Study Name] ),
        0,
        IF (
            CALCULATE ( COUNTROWS ( Majorslicer ) )
                == CALCULATE ( COUNTROWS ( Majorslicer ), ALL ( Majorslicer ) ),
            1,
            CALCULATE ( COUNTROWS ( Majorslicer ), ALL ( Majorslicer ) )
                - CALCULATE ( COUNTROWS ( Majorslicer ) )
        )
    )
VAR SelectedMinorCount =
    IF (
        NOT ISFILTERED ( Minorslicer[Area of Study Name] ),
        0,
        IF (
            CALCULATE ( COUNTROWS ( Minorslicer ) )
                == CALCULATE ( COUNTROWS ( Minorslicer ), ALL ( Minorslicer ) ),
            1,
            CALCULATE ( COUNTROWS ( Minorslicer ), ALL ( Minorslicer ) )
                - CALCULATE ( COUNTROWS ( Minorslicer ) )
        )
    )
RETURN
    IF (
        (
            MAX ( Courses[CourseSK] ) IN a
                && SelectedMajorCount > 0
        )
            || (
                MAX ( Courses[CourseSK] )
                    IN b
                    && SelectedMinorCount > 0
            ),
        1,
        0
    )

See if this helps!!!. Thank you:)