DAX: The =RELATED() Function
A quick update here on the football project (not really warranting a video). The source db is awfully complex, and I’m in the process of wrapping my Excel-centric head around it.
For instance, in the Plays table, I’m trying to understand how many row constitute a single NFL play. It’s not one row per play – no, that would be too simple.
Here, for instance, is a field that claims to be a unique play ID, but when I sort by it, it clearly isn’t: