Forum Discussion
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! 🙂
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-msftCommunity 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_ukHelper 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
- analytics_ukHelper I
- Tahreem24Super User
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_ukHelper 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