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