Results 1 to 2 of 2

Thread: Sum and Average in the same measure

  1. #1

    Sum and Average in the same measure



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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!

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    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,

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •