Forum Discussion

AllanBerces's avatar
AllanBerces
Post Prodigy
1 year ago
Solved

Not equal

Hi good day, 

Can anyone help me on how to simplify the part of my calculated column. The Bold and underline portion

 

Forecast = FILTER(SUMMARIZE('Data',
'Data'[Date],
'Data'[Subcon],
'Data'[TA],
'Data'[WNT],
 "ForecastHrs", CALCULATE(SUM('Data'[ForecastHrs])),
 "Hoursperday", CALCULATE(SUM('Data'[Hours Per day]))),
 [Subcon] IN {"A", "B", "C"}
 && [TA] = "TA25"
 && [WNT] <> "FA5"
 && [WNT] <> "EG1"
 && [WNT] <> "Asset"
)

Thank you

Need Help
  • vojtechsima's avatar
    vojtechsima
    1 year ago

    Hey man, AllanBerces 

    use the same IN approach like above, just with NOT operator:

    Forecast =
FILTER (
    SUMMARIZE (
        'Data',
        'Data'[Date],
        'Data'[Subcon],
        'Data'[TA],
        'Data'[WNT],
        "ForecastHrs", CALCULATE ( SUM ( 'Data'[ForecastHrs] ) ),
        "Hoursperday", CALCULATE ( SUM ( 'Data'[Hours Per day] ) )
    ),
    [Subcon] IN { "A", "B", "C" }
        && [TA] = "TA25"
        && NOT ( [WNT] IN { "FA5", "EG1", "Asset" } )
)

3 Replies

  • vojtechsima's avatar
    vojtechsima
    Super User
    1 year ago

    Hey man, AllanBerces 

    use the same IN approach like above, just with NOT operator:

    Forecast =
FILTER (
    SUMMARIZE (
        'Data',
        'Data'[Date],
        'Data'[Subcon],
        'Data'[TA],
        'Data'[WNT],
        "ForecastHrs", CALCULATE ( SUM ( 'Data'[ForecastHrs] ) ),
        "Hoursperday", CALCULATE ( SUM ( 'Data'[Hours Per day] ) )
    ),
    [Subcon] IN { "A", "B", "C" }
        && [TA] = "TA25"
        && NOT ( [WNT] IN { "FA5", "EG1", "Asset" } )
)