Forum Discussion

SebSchoon1's avatar
SebSchoon1
Post Patron
3 years ago

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...
Need Help
DimaMD's avatar
DimaMD
Solution Sage
3 years ago

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's avatar
SebSchoon1
Post Patron
3 years ago

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's avatar
    DimaMD
    Solution Sage
    3 years ago

    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's avatar
      SebSchoon1
      Post Patron
      3 years ago

      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's avatar
        DimaMD
        Solution Sage
        3 years ago

        SebSchoon1  Yes, it is strange

    • SebSchoon1's avatar
      SebSchoon1
      Post Patron
      3 years ago

      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's avatar
        DimaMD
        Solution Sage
        3 years ago

        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())