DAX: Average on a SUM

[martijnvanderveldt]

Heyy!

Somehow, DAX doesn't allow me to do the following in a measure:

Average(SUM(Volume A)/SUM(Volume A+B))

Anyone any idea how i could work around this. I need it for an IF function (If higher than average..).

Thanks guys!

 

[scottsen]

AVERAGE only works on columns, do work on a Measure, you need to use AVERAGEX.