Forum Discussion
Data modeling not working
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 wor...
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