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

       

      • SebSchoon1's avatar
        SebSchoon1
        Post Patron
        3 years ago

        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.