Data modeling not working

[ishanjain]

I have 2 tables- hierarchy_SA and historical_accuracy and modeled through 1: many relationship with a column called Service_area. I created some measures in the historical_accuracy table and they work fine when I use the Service_area column thru the same table (historical_accuracy). But when I use the Service_area column from the hierarchy_SA table, the measures break and give me incorrect results. Any ideas?

[eliasayy]

hello @ishanjain ,
try creating a measure for this:

Measure = 
CALCULATE (
SUM(historical_accuracy[Historical_Accuracy_Score]),
historical_accuracy[SERVICE_AREA] IN VALUES ( hierarchy_SA[SERVICE_AREA] )
)

and sum can be exchanged by max or min or whatever expression you want