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