Forum Discussion
nmck86
Post Patron
Post PatronPercentage Difference By Product
Hello! I have a table setup like below:
Product Score
A 10
B 20
C 30
D 40
Overall Score = 75
The product field is coming from one table and the scores are coming from the same location as he overall score and are actually the same field and the relationship is set in a way that causes the data set to filter down. If I waned to show the Overall Score without it filtering it down by product, how would I do that? Also, once I do that I would like to see the difference as a new measure. So for instance the first one product A would have a difference of 65.
Product Score
A 10
B 20
C 30
D 40
Overall Score = 75
The product field is coming from one table and the scores are coming from the same location as he overall score and are actually the same field and the relationship is set in a way that causes the data set to filter down. If I waned to show the Overall Score without it filtering it down by product, how would I do that? Also, once I do that I would like to see the difference as a new measure. So for instance the first one product A would have a difference of 65.
No worries! I figured this one out.
3 Replies
v-piga-msftResident Rockstar
Hi nmck86,
I'm not very clear about your scenario, could you describe it in more details?
If it is conveinet, could you share some data sample and your desired output, so that we can help further investigate on it?
Best Regards,
Cherry
nmck86No worries! I figured this one out.
- v-piga-msft
Hi nmck86,
Congratulations!:smileywink:
If it is convenient, could you share the solution to your question so that people who may have the same question can get the solution directly.
Best Regards,
Cherry