How not to count blank values in total?

[MarkShu]

Hello! How not to count blank values in total? For example I should get 70% insted of 47% in the last column. 

[v-chuncz-msft · Accepted solution]

@MarkShu ,

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/Average-of-a-measure-for-each-value-of-the-years/m-p/312310...