Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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! 🙂
Solved! Go to Solution.
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
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
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
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.
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
Hi , @analytics_uk
You're welcome.
And please mark your reply as Answered to close the thread if your problem has been solved.
Best Regards,
Community Support Team _ Eason
Answered!
Good to know that you issue resolved. But, if you refer my post so I created Calculated Column to get the expected result.
Don't forget to give thumbs up 👍 and accept this as a solution if it helped you.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |