UseRelationship Not Working as Expected

Hi Anonymous ,

I am assuming that your Master Data has

1. NAme of Runners (Dogs).

2. Track Name (i.e 50m, 100m, etc)

3. Time Rating (i.e Time the runner took at each of these races)

And you want to Calculate Avg time the runner took for each of the tracks.

CALCULATE(AVERAGE(MasterData[TimeRating]),ALLEXCEPT(MasterData, MasterDate[Track],MasterData[RunnerName]))

Pull the runner name from Master Table, Track from master table and the measure above.

Incase this is not the scenario, pls share your relationships and sample Data.

Thanks,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

In case it did not help, please provide additional information and mark me with @ so that I can investigate further