Data modeling not working

ishanjain — Wed, 18 Jan 2023 21:25:14 GMT

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?

Re: Data modeling not working

Anonymous — Thu, 19 Jan 2023 00:20:10 GMT

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

topic Data modeling not working in DAX Commands and Tips

Data modeling not working

Re: Data modeling not working