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!

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!