Forum Discussion

Helper IV

9 years ago

IF

Bonjour, Je ne comprends pas pourquoi ma fonction retourne tout le temps la même valeur (la première si), tandis que ma colonne PFCCTTAXE retourne parfois 0 ou 1. Je ne includes Pourquoi pas ...

Helper IV

9 years ago

Hello,

I don't understand why my function returns all the time the same value (the first if) while my column PFCCTTAXE sometimes returns 0 or 1.

Je ne comprend pas pourquoi ma fonction retourne tout le temps la même valeur (le premier if) alors que ma colonne PFCCTTAXE retourne parfois 0 ou 1.

Colonne = IF(VALUE(Factures[PFCTCTAXE])<> 0||1;Factures[PFCNMT]-Factures[PFCNMTVA];IF(VALUE(Factures[PFCTCTAXE])= 0||1;0))

Baskar
Resident Rockstar
9 years ago
Cool dude cool,

Do u want create calculated column or Measure ?

For column try this :

Column = Switch ( True() ,
Factures[PFCTCTAXE] <> 0 || Factures[PFCTCTAXE] <> 1,Factures[PFCNMT]-Factures[PFCNMTVA],
Factures[PFCTCTAXE]= 0 && Factures[PFCTCTAXE] =1 , 0
)

Measure :

Measure =
Var Contion= SUM(Factures[PFCTCTAXE])
Switch ( True() ,
Contion <> 0 || Contion <> 1; SUM(Factures[PFCNMT])-SUM(Factures[PFCNMTVA])
Contion = 0 && Contion = 1 , 0
)

Let me know if any help
v-sihou-msft
Microsoft Employee
9 years ago
AlexGallet01

In this scenario, I think you need to adjust your condtion in your IF statement for correct coverage. Your logic should be:

1. IF "Factures[PFCTCTAXE]) = 0" OR "Factures[PFCTCTAXE]) = 1", THEN 0

2. IF "Factures[PFCTCTAXE]) <> 0" AND "Factures[PFCTCTAXE]) <> 1" THEN "Factures[PFCNMT]-Factures[PFCNMTVA]"

So your formula should be like:

COLUMN = Switch ( True() , Factures[PFCTCTAXE] = 0 || Factures[PFCTCTAXE] = 1, 0, Factures[PFCTCTAXE] <> 0 && Factures[PFCTCTAXE] <> 1, Factures[PFCNMT]-Factures[PFCNMTVA] )

Regards,