Filtered Value

[amandabus21]

Hi, 

I used the Filtered Value on a measure:

FRB Status Math =

CALCULATE(

    [FRB Status],

    'TTrack_DailyIncidentTable'[NTD_Status] IN {

        "Major Mechanical System Failures (NTD)",

        "Other Mechanical System Failures (NTD)"} ,

        TTrack_DailyIncidentTable[NTD_Status] IN { "Equipment Failure / Roadcall"} ,

        MilesAndHours_Bus[Division] IN {"East County Garage", "Copley Park Garage", "South Bay Garage"} )

But I would like to it to also EXCLUDE " 2018,2019,2020,2021" from'Dim DimDate'[Merged]

How could i write that in?

[FreemanZ]

hi @amandabus21 

try like:

FRB Status Math =

CALCULATE(

    [FRB Status],

    'TTrack_DailyIncidentTable'[NTD_Status] IN {

        "Major Mechanical System Failures (NTD)",

        "Other Mechanical System Failures (NTD)"} ,

        TTrack_DailyIncidentTable[NTD_Status] IN { "Equipment Failure / Roadcall"} ,

        MilesAndHours_Bus[Division] IN {"East County Garage", "Copley Park Garage", "South Bay Garage"} ,

        NOT  'Dim DimDate'[Merged] IN {2018,2019,2020,2021}

)

[amandabus21]

thanks but getitng this errror: 

I dont have any 'Contains Row" in my measure.

[FreemanZ]

aha, then try like:

FRB Status Math =

CALCULATE(

    [FRB Status],

    'TTrack_DailyIncidentTable'[NTD_Status] IN {

        "Major Mechanical System Failures (NTD)",

        "Other Mechanical System Failures (NTD)"} ,

        TTrack_DailyIncidentTable[NTD_Status] IN { "Equipment Failure / Roadcall"} ,

        MilesAndHours_Bus[Division] IN {"East County Garage", "Copley Park Garage", "South Bay Garage"} ,

        NOT  YEAR('Dim DimDate'[Merged]) IN {2018,2019,2020,2021}

)