Forum Discussion

Analitika's avatar
Analitika
Icon for Post Prodigy rankPost Prodigy
4 years ago

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's avatar
Hariharan_R
Icon for Solution Sage rankSolution 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's avatar
Analitika
Icon for Post Prodigy rankPost 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"}.