Building Scorecard

[Anonymous]

I have data like this in PBI:

 All columns here would be calculated measures in PBI from different datasets. All tied together through relationships.

So based off of these tables below:

 

I'm looking for something that in turn would give me a final result of something like this:

This is something I've been tasked with but I really have no clue on how to build something like this. Can anyone show me the general gist of how to put something like this together? I'm not sure if I need to use calculated columns vs. measures or what the easiest way is to put this together...

[v-yuta-msft]

Hi mrainey,

Could you please provide more details about your tables and specific requirement?

Regards,

Jimmy Tao

[Anonymous · Accepted solution]

Hi @v-yuta-msft , I've figured it out now. Thank you for reaching out!