DAX's CALCULATE() function - Pivots will never be the same
THE GREAT FOOTBALL PROJECT RETURNS! Oh yes, it has been a long time indeed.
When I last worked on the football project, I had designed my first report and started the process of better understanding my source data, primarily using the =RELATED() function. I mentioned a couple of times that the yardage totals being displayed were not yet trustworthy, and that they needed a lot of work before they were accurate.
Let’s get started on making them accurate, because, well, accurate is good. We like accurate.