calculate different filter text field

[rogeriotortosaParticipant Started: 6Replies: 12Total: 18]

I’m having trouble calculating the total amount of sale, provided that not be for some customers

Example:

Total Qtde Sales:=SUM(fatNFAutorizada[Quantidade]) ==> 676.544

Total Qtde Sales Client XXXX:= CALCULATE(SUM(fatNFAutorizada[Quantidade]);dimClientes[idCliente]<>”36251″ || dimClientes[idCliente]<>”58471″) ==> 552.244

Problem:
both formulas are returning the same value, instead of the value as above

Help me

att

Rogerio

[tomallanKeymaster Started: 0Replies: 417Total: 417]

Hi Rogerio,

Logical expressions that work with a logical “||” and negations can often catch us off our guard.

As an operator for the non-exclusive logical “OR”, when “||” is used, if any one (or only one) condition is true, the expression is true.

The expression

dimClientes[idCliente]<>“36251” || dimClientes[idCliente]<>“58471”

is always true. If the client’s id is 36251, then it must be true that the client’s id is not 58471, and the “at least one condition” criteria is satisfied. The reverse is also true on the “at least one condition criteria”. If the client is id is neither 36251 or 58471, both conditions are true.

Since we are working with negations, try:

dimClientes[idCliente]<>“36251” && dimClientes[idCliente]<>“58471”

and let me know how things progress.

Tom

[rogeriotortosaParticipant Started: 6Replies: 12Total: 18]

perfect

tks Tom

[Author]

Posts