Show Parameters across 2 visuals using 1 Slicer

[adoster]

I have a visual which shows Height and Weight values for "Count" and "Compliance%" using the following code

ComplianceCount = {

    ("Count", NAMEOF('Metrics'[CountHeight]), 0, "Height"),

    ("Compliance", NAMEOF('Metrics'[ComplianceHeight]), 1, "Height"),

    ("Count", NAMEOF('Metrics'[CountWeight]), 2, "Weight"),

    ("Compliance", NAMEOF('Metrics'[ComplianceWeight]), 3, "Weight")

}

I would like to separate this into 2 visuals so that if I select on the Slicer Height it will show Count on 1st visual and Compliance on 2nd visual. Same for selecting Slicer Weight value.

Thank you!

[adoster · Accepted solution]

I was able to work out a solution to this.

Step 1: Create a reference table

DimCompliance =

DATATABLE(

    "MeasureName",STRING,

    "ID",INTEGER,

    {

        {"Height",1},

        {"Weight",2},

    }

)

Step 2: Create 2 Switch Measures

CountSwitch =

SWITCH (

    SELECTEDVALUE ( DimCompliance[ID] ),

    1, [CountHeight],

    2, [CountWeight]

)

ComplianceSwitch =

SWITCH (

    SELECTEDVALUE ( DimCompliance[ID] ),

    1, [ComplianceHeight],

    2, [ComplianceWeight]

)

Step 3: Create 2 visuals using Switch Measures