Wrong calculation measure in Power BI

Hello, I would like to ask how to exclude additional type from table. _Gauta, EUR = CALCULATE( [__Lik_Suma] ,FILTER( _APV, (CONTAINSSTRING([apyvarta.operacija],"Pajama...

Need Help

Hariharan_R

Solution Sage

4 years ago

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
Post Prodigy
4 years ago
But I need to not include this [apyvarta.operacija] in {"Skolos tiekejams"}. How to achieve this, I used not [apyvarta.operacija] in {"Skolos tiekejams"}.

Forum Discussion

Wrong calculation measure in Power BI