DAX CALCULATE, and Rapid Iteration

Ok, in the last football post, I had written the following measure:

=CALCULATE(sum([Yards]).Plays[PlayTypeName]="RUN-Run")

Which basically means, “sum up the [Yards] column but only those rows with [PlayTypeName] = “RUN-run” “

Now we get to find out if it works :)

I need some real-world data that I can validate against.  Out on NFL.com I can find historical player stats.  Let’s look at one of my favorite players from recent years, Priest Holmes.  He amassed a lot of Rushing Yards and should be a good sample.  Here are his statistics by Game for 2004: