Introduction The most used functions in DAX have to be SUM(), COUNT() (and it’s colleagues) and AVERAGE(). There is no big deal with the first two. AVERAGE() however, has to be properly thought through
Introduction Struggling to write measures is usually down to one’s understanding of Filters context. This is because DAX is computed based on an Evaluation context which consists primarily of 2 contexts: The Row Context