calculate % of progress by getting targets from another table

[StatInsight]

Hello,

I am very new to PBI and this is my very first post in here. 

I have a problem to calculate progress. Let me explain the way best I can. This involves plant nurseries, at the start of the year they are given targets. (number of plants to be produced.) Lets say plants can be two types, Pepper and Cinnamon.

So time to time they produce some quantity of plants and issue produced plants (to farmers). 

so progress a plant type = (total produced quantity) / target for that plant time of that nursery

I want to create a measure to do so. please help.

I have attached some images if that helps.

Thank You.

[LivioLanzo]

Could you share your pbix file?

[StatInsight]

At the time I didn't know I can share pbx files here. Thanks for your reply.

I figured out how to do it now. 

Cheers ...!!!

[v-yulgu-msft]

Hi @StatInsight,

Glad to hear that you have worked it out. Would you please share the solution so that it can benefit more community members?

Thanks,

Yuliana Gu