Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |