Forum Discussion

ishanjain's avatar
ishanjain
Frequent Visitor
3 years ago

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 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?

 

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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