Sum and Average in the same measure

martijnvanderveldt

New member
Joined
Sep 10, 2014
Messages
10
Reaction score
0
Points
0
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!
 
Assuming your Volumes A and B are actually ranges of values, then how about this:

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

Cheers,
 
Back
Top