Forum Discussion

joshua1990's avatar
joshua1990
Icon for Post Prodigy rankPost Prodigy
3 years ago
Solved

FILTER NOT CONTAINS

Hi all! Let's say I have a table with values and string. In the column Article I have different strings. Now I would like to calculate the SUM of the column Quantity but I would like to exclude...
Need Help
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi joshua1990 

    please try

    Sales :=
CALCULATE (
    [Sales Amount],
    NOT ( 'Sales'[Article]
        IN { "Article1", "Article2", "Article3", "Article4", "Article5" } )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi joshua1990 

please try

Sales :=
CALCULATE (
    [Sales Amount],
    NOT ( 'Sales'[Article]
        IN { "Article1", "Article2", "Article3", "Article4", "Article5" } )
)