The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
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
But I need to not include this [apyvarta.operacija] in {"Skolos tiekejams"}. How to achieve this, I used not [apyvarta.operacija] in {"Skolos tiekejams"}.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
14 | |
12 | |
3 | |
3 | |
2 |