DAX CALCULATE, and Rapid Iteration
User Rating: / 1
PoorBest 
Written by Rob Collie   
Thursday, 17 December 2009 04:08
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:
  Tags: excel, dax
 

Varigence Vivid