Example Measures Using Disconnected Table as Slicer

Counter Type is a dimension that has a column [Counter Type Name]. Counter Type is in a slicer.

Determine what [Counter Type Name] is selected and based on that calculate the difference count between

Azure and Snowflake.

-- get the difference between azure and snowflake

Count Difference =

VAR SelectedCounter = SELECTEDVALUE('Counter Type'[Counter Type Name])

VAR CounterTypeCount =

SWITCH(

SelectedCounter,

"> 30 SEC", [CKR Count > 30 Sec] - [Snowflake Count > 30 Sec],

"> 60 SEC", [CKR Count > 60 Sec] - [Snowflake Count > 60 Sec],

"> 120 SEC", [CKR Count > 120 Sec] - [Snowflake Count > 120 Sec],

"> 180 SEC", [CKR Count > 180 Sec] - [Snowflake Count > 180 Sec],

"> 240 SEC", [CKR Count > 240 Sec] - [Snowflake Count > 240 Sec],

"> 300 SEC", [CKR Count > 300 Sec] - [Snowflake Count > 300 Sec],

"> 360 SEC", [CKR Count > 360 Sec] - [Snowflake Count > 360 Sec],

"> 420 SEC", [CKR Count > 420 Sec] - [Snowflake Count > 420 Sec],

"> 480 SEC", [CKR Count > 480 Sec] - [Snowflake Count > 480 Sec],

"> 540 SEC", [CKR Count > 540 Sec] - [Snowflake Count > 540 Sec],

"> 600 SEC", [CKR Count > 600 Sec] - [Snowflake Count > 600 Sec],

"> 1800 SEC", [CKR Count > 1800 Sec] - [Snowflake Count > 1800 Sec]

)

RETURN CounterTypeCount

-- get the count for azure drive thru

CKR Count =

VAR SelectedCounter = SELECTEDVALUE('Counter Type'[Counter Type Name])

VAR CounterTypeCount =

SWITCH(

SelectedCounter,

"> 30 SEC", [CKR Count > 30 Sec],

"> 60 SEC", [CKR Count > 60 Sec],

"> 120 SEC", [CKR Count > 120 Sec],

"> 180 SEC", [CKR Count > 180 Sec],

"> 240 SEC", [CKR Count > 240 Sec],

"> 300 SEC", [CKR Count > 300 Sec],

"> 360 SEC", [CKR Count > 360 Sec],

"> 420 SEC", [CKR Count > 420 Sec],

"> 480 SEC", [CKR Count > 480 Sec],

"> 540 SEC", [CKR Count > 540 Sec],

"> 600 SEC", [CKR Count > 600 Sec],

"> 1800 SEC", [CKR Count > 1800 Sec]

)

RETURN CounterTypeCount

-- get the azure units missing

Azure Units Missing =

VAR UnitDifference =

ADDCOLUMNS(

    SUMMARIZE(

        'Unit',

        'Unit'[UNIT_NUMBER]

    ),

"@AzureCount", [CKR Count],

    "@Difference", [Count Difference]

)

RETURN

CALCULATE(

COUNTROWS(

FILTER(

UnitDifference,

NOT ISBLANK([@Difference]) && [@Difference] <> 0 && ISBLANK([@AzureCount])

)

)

)