Main Fact VS Target Fact (KPI's)

[Anonymous]

Greeting members 

i have 2 fact tables : Fact_School where there is all  details about the school everyday  and another table called School_target where i have the target detail per month .

Fact _School : 

School_target : 

both tables have a relation with a Dim_date and dim_class .

what im trying to calculate is the pourcentage of  charge acheived and  the pourcentage of  charge acheived YTD.

Thanks all for your help.

[amitchandak · Accepted solution]

@Anonymous 

Create measures like

Ratio=  divide(Sum(fact_school[Charges]), sum(Target[Target]))

Ratio YTD = calculate([Ratio], datesytd(Date[Date]))

Along with common date table, have common school table too