Forum Discussion

analytics_uk's avatar
analytics_uk
Icon for Helper I rankHelper 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 t...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    6 years ago

    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

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
6 years ago

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
    Icon for Helper I rankHelper I
    6 years ago

    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