Average grade

Hi  Anonymous ,

Create a measure as below:

_Average total = 
var _sumxtotal=SUMX(FILTER(ALLSELECTED('grade unit calculated'),'grade unit calculated'[Unit code]=MAX('grade unit calculated'[Unit code])),'grade unit calculated'[N=])
var _sumalltotal=SUMX(FILTER(ALLSELECTED('grade unit calculated'),'grade unit calculated'[Unit code]=MAX('grade unit calculated'[Unit code])),'average grade'[multiple])
Return
IF(ISINSCOPE('grade unit calculated'[Unit code]),DIVIDE(_sumalltotal,_sumxtotal),BLANK())

And you will see:

For the updated .pbix file,pls click here.

Hi Anonymous 

Thanks for the new measure. 

Is there a way to show just one measure instead of having a table which need two measures?

This new measure has a new problem: in my original database, unit code is in a different file (see image ). I tried to adapt the measure, but it didn't show any results. 

I added this to the sample set:

https://drive.google.com/file/d/1BwAt6xqgJIOpAiAUjQGcnXSqDwb8bNDi/view?usp=sharing

But I really hope I could use one measure to show the average for the units as well as for the locations. I hope you could help me once again. 

Kind regards,

Johan