Not equal

[AllanBerces]

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

[vojtechsima · Accepted solution]

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

[AllanBerces]

Hi @vojtechsima thank you very much for the reply. working as i need.

[vojtechsima]

Happy to help @AllanBerces