Dear Sirs, I tried to use the operator "NOT ( ! ) unsuccessfully, help me whith exemples. thanks.

[Aldair]

Prezados Senhores, eu tentei usar o operador "NÃO (!) Sem sucesso, me ajudar com o exemplo.

[vanessafvg]

@Aldair can you give an example of what you tried already and what you are trying to do?

[Aldair]

GROSS REVENUE = ABS(CALCULATE([Valor Contábil];CT1010[CTA SUPERIOR]<>"31101"))!CT1010[CTA SUPERIOR]="41101"))

[vanessafvg]

@Aldair

GROSS REVENUE = ABS(CALCULATE([Valor Contábil],Filter (CT1010, CT1010[CTA SUPERIOR]<>"31101"

                                                                                                  && CT1010[CTA SUPERIOR]="41101"))

[Aldair]

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.

[vanessafvg · Accepted 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"))

[vanessafvg · Accepted 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"))

[Aldair]

Dear Sirs, I tried to use the operator "NOT ( ! ) unsuccessfully, help me whith exemples. thanks.

[prateekraina]

Hi @Aldair,

Can you please elaborate your requirement?

Thanks !!

[gopichilla]

Can you post the detailed formula for that?