How to create a new average from results in one table and add the result into another table?

[ceekay89]

I am new to power Bi

I have two tables:

one with data as an average for 70% & 80% pass mark for pupils at 5 schools

the second table has actual number of student passed with 30%, 40%, 50% and 70% &80%pass mark for one new school

I want to find the average for 70% & 80% pass mark out of all the marks in the new school and then add it to the other table to compare against other schools pass marks at 70%.

I think i will need to create an average of  70 and 80% marks in one table and then add the result to the other table? How can I do this within Power Bi? 

[Anonymous]

Hi @ceekay89,

It will be help if you provide some sample data about your requirement.

Regards,

Xiaoxin Sheng