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?