Forum Discussion

amandabus21's avatar
amandabus21
Icon for Helper V rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper V rankHelper V
    3 years ago

    thanks but getitng this errror: 

     

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

    • FreemanZ's avatar
      FreemanZ
      Icon for Super User rankSuper 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}
      )