Forum Discussion
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))
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