Forum Discussion
Analitika
Post Prodigy
Post ProdigyWrong 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],"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?
2 Replies
- Hariharan_R
Solution Sage
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"}.
