Wrong calculation measure in Power BI

[Analitika]

Hello,

I would like to ask how to exclude additional type from table. 

_Gauta, EUR = 
CALCULATE(
    [__Lik_Suma]
    ,FILTER(
        _APV,
        (CONTAINSSTRING([apyvarta.operacija],"Pajamavimas") && not [apyvarta.operacija] in {"Turto pajamavimas"} )
        || CONTAINSSTRING([apyvarta.operacija],"Gauta")
        || CONTAINSSTRING([apyvarta.operacija],"Pradinis")

    )
)

When I add additional containsstring in formula nothing changes. For example, if I add && not  

not [apyvarta.operacija] in {"Skolos tiekejams"}. So what be correct solution?

[Hariharan_R]

Hi @Analitika 

You need to use your base column which contains the word. I think you are refering the measure and it will be always one value check. 

Also || you want to filter, isn't it? please add with in Filter.

Try like above.  

Result =
CALCULATE (
    SUM ( 'Table'[Value] ),
    FILTER (
        'Table',
        CONTAINSSTRING ( 'Table'[Category], "Pajamavimas" )
            && NOT 'Table'[Category]
                IN { "Turto pajamavimas" } || CONTAINSSTRING ( 'Table'[Category], "Gauta" )
                    || CONTAINSSTRING ( 'Table'[Category], "Pradinis" )
    )
)

Thanks

Hari

Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

My Blog :: YouTube Channel :: My Linkedin

[Analitika]

But I need to not include this [apyvarta.operacija] in {"Skolos tiekejams"}. How to achieve this, I used not  [apyvarta.operacija] in {"Skolos tiekejams"}.