Forum Discussion

amandabus21's avatar
amandabus21
Helper V
3 years ago

Filtered Value

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?

3 Replies

  • FreemanZ's avatar
    FreemanZ
    Super User
    3 years ago

    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's avatar
      amandabus21
      Helper V
      3 years ago

      thanks but getitng this errror: 

       

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

      • FreemanZ's avatar
        FreemanZ
        Super User
        3 years ago

        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}
        )