Forum Discussion
Measure provide wrong result
Hello all, I have a strange behavior I do not understand, I make multiple measures which are giving me the expected values But then i want to use this result to a final step and it does n...
Hello DimaMD
thank you for having taken a glance on it.
May i ask you why the information i see on my table is not verified with IF measures?
my formula to test
Test Qté articles = if([(1) Total des reliquats]=2,"y","n")
the result (Wrong)
It shows me "n" eve if my items are = to 2
here's my formula to obtain "(1)Total des reliquats"
(1) Total des reliquats = if([Rank Pour Dispatch]<>BLANK(),CALCULATE(([(1)Nombre décimal Répartition]*[Nb Dépots stocks dispo]),ALLSELECTED('Tableau Dispatch'[CODE DEPOT])),BLANK())µ
here is how i obtain the Décimal part of repartition
(1)Nombre décimal Répartition = CALCULATE(MOD([(1)Répartition par stock],1))
Here is how i obtain the number of authorised warehouses ([Nb Dépots stocks dispo])
Nb Dépots stocks dispo = if([Rank Pour Dispatch]<>blank(),CALCULATE(DISTINCTCOUNT('Tableau Dispatch'[CODE DEPOT]),all('Dépots et etablissements'[CODE DEPOT])),BLANK())
it is really a strange behavior no?
SebSchoon1 Yes, it is strange