Measure provide wrong result

[SebSchoon1]

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 not work..

Here's my report with information

I say,

If [Rank Pour Dispatch] <= [(1) Total des reliquats] Then 1 otherwise Blank()

But it does not work, Any idea?

Kind regards

[SebSchoon1]

Hello @DimaMD  here's a link

🙂

https://we.tl/t-GPXPMGuUKB

[DimaMD]

@SebSchoon1 I made changes to this event and the event with the condition worked

But your data in the picture do not match what you provided

[SebSchoon1]

@DimaMD  I have sent another link

where you can find both examples.

https://we.tl/t-6aPbNaUszH

[SebSchoon1]

Wow,

may thanks for going into this,

it is strange that the date are different

here's another link with two examples

one where it works as expected.

and another one (just below) 

Whioch does not work and i don't no why 😞

https://we.tl/t-6aPbNaUszH

[DimaMD]

Hi @SebSchoon1 After examining the fascist sample data, I found that your measure (1) Total des reliquats gives the wrong value. 
I suggest you use (1)Nombre entier Répartition in your event:

If(
    [Rank Pour Dispatch] <= [(1)Nombre entier Répartition] && [Rank Pour Dispatch] <> BLANK() , 1, Blank())

[SebSchoon1]

Hello @DimaMD 

Concerning the measure, it will not work since

if i have two items for 3 wharehouse it will not split the remaining quantities

since full number is 0 and remaining quantities = 0.67  

it will not consider  the total remaining quantities  (0.67 * 3 ) = 2 

So it will not work 🙂

[DimaMD]

@SebSchoon1 I'm sorry, after looking at your first post, I realized that you are not fulfilling the condition correctly,
Your condition should be like this change <= to >=

(1)Attribution des reliquats = If([Rank Pour Dispatch]<>blank() && [Rank Pour Dispatch] >= [(1) Total des reliquats] ,1,Blank())

 

[SebSchoon1]

Hello,

it does not work, since I'd like to Have Rank 1 As most important priority

:s I think that it must come from my [(1)Total de reliquats ARTICLE]

Wich seems to show results but if fact it is wrong.

[SebSchoon1]

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?

[DimaMD]

@SebSchoon1  Yes, it is strange

[DimaMD]

hi @SebSchoon1  Try it 

if = If [Rank Pour Dispatch] <= [(1) Total des reliquats],1, Blank()

Without sample data, it is difficult to conduct analyses