Forum Discussion

analytics_uk's avatar
analytics_uk
Helper I
6 years ago
Solved

DAX measure

Hello!

I'd love help with the below. Even though the column "YoY" is negative it's still giving me "Great" when it supposed to give me "Risk". Many thanks in advance! 🙂

 
SKU Status = IF('Sell through'[Sell Through Units YoY] >= 0, "Great", "Risk")
 
 

 

 
 
  • Hi , analytics_uk 

    Invoking another method in a method can easily produce deviations in the results, if you do not pay attention to the use of filtering effects.

    Looks like your  'Sell through'[Sell Through Units YoY]  is also a measure.

    Can you show me   the formular   of    'Sell through'[Sell Through Units YoY]  and other related measures  ?

     

    Best Regards,
    Community Support Team _ Eason

8 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support

    Hi , analytics_uk 

    Invoking another method in a method can easily produce deviations in the results, if you do not pay attention to the use of filtering effects.

    Looks like your  'Sell through'[Sell Through Units YoY]  is also a measure.

    Can you show me   the formular   of    'Sell through'[Sell Through Units YoY]  and other related measures  ?

     

    Best Regards,
    Community Support Team _ Eason

    • analytics_uk's avatar
      analytics_uk
      Helper I

      Hi!

       

      Thanks for taking the time to look into this for me.

      I actually managed to find the issue.

      Instead of creating a measure I created a calculated column.

       

      Cheers,

      Renata 

    • Tahreem24's avatar
      Tahreem24
      Super User

      analytics_uk ,

       

      I tried to replica your issue at my end and it is giving me correct result. If possible so can you please sample data without any confidential details.

       

      Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.

       

      • analytics_uk's avatar
        analytics_uk
        Helper I

        Hi!

        Thanks for taking the time to look into this for me.

        I actually managed to find the issue. Instead of creating a measure I created a calculated column.

         

        Cheers,

        Renata