Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Prezados Senhores, eu tentei usar o operador "NÃO (!) Sem sucesso, me ajudar com o exemplo.
Solved! Go to Solution.
@Aldair as always there are many ways to do one thing, have tried to figure out the ! but none of my syntax is working.. however you might not need it, as you can use
measure = calculate(measure, not(condition = "value"))
Proud to be a Super User!
@Aldair can you give an example of what you tried already and what you are trying to do?
Proud to be a Super User!
GROSS REVENUE = ABS(CALCULATE([Valor Contábil];CT1010[CTA SUPERIOR]<>"31101"))!CT1010[CTA SUPERIOR]="41101"))
GROSS REVENUE = ABS(CALCULATE([Valor Contábil],Filter (CT1010, CT1010[CTA SUPERIOR]<>"31101"
&& CT1010[CTA SUPERIOR]="41101"))
Proud to be a Super User!
Thanks. At what time / situation can I use the NOT (!) Operator? Is it with measure / column calculated? I wanted one or a few examples. At the moment it is for knowledge. Thank you very much.
@Aldair as always there are many ways to do one thing, have tried to figure out the ! but none of my syntax is working.. however you might not need it, as you can use
measure = calculate(measure, not(condition = "value"))
Proud to be a Super User!
Dear Sirs, I tried to use the operator "NOT ( ! ) unsuccessfully, help me whith exemples. thanks.
Can you post the detailed formula for that?
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |