Percentage Difference By Product

[nmck86]

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.

[v-piga-msft]

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

[nmck86 · Accepted solution]

No worries! I figured this one out. 

[v-piga-msft]

Hi @nmck86,

Congratulations!

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