PDA

View Full Version : Sum and Average in the same measure



martijnvanderveldt
2015-11-13, 03:52 PM
Heyy everyone!
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 a lot!

CheshireCat
2015-11-16, 09:58 PM
Assuming your Volumes A and B are actually ranges of values, then how about this:



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


Cheers,