Forum Discussion
Higher grain Summarization
Dear DAX community, I want to understand the difference between AVERAGE and AVERAGEX in terms of working method and capacity. The formula for the average is SUM(amount)/Number of Instance. AVER...
AVERAGE and AVERAGEX does not equal to SUM( Amount ) / Number Of Instances. This is a misconception. If [Amount] is BLANK, this amount is not considered. So, fir instance, AVERAGE of (1, 1, BLANK, BLANK) = 2/2, not 2/4. If you want to force the recognition of BLANKs, you have to add 0 to them. So, AVERAGE of (1, 1, BLANK + 0, BLANK + 0) = 2/4.