Forum Discussion

perezco's avatar
perezco
Advocate III
4 years ago

Calculate dax average function after divide two columns measures

Hi all, How can calculate dax average function after divide two columns measures? (The denominator and numerators are both measures)
Need Help
Tips and Tricks
  • perezco's avatar
    perezco
    Advocate III
    4 years ago

    Divide(num_column,deno_column)first, then the average function said that it is exclusively for column.

    Does exist any work around ?

    • v-jingzhang's avatar
      v-jingzhang
      Community Support
      4 years ago

      Hi perezco 

       

      You can put both measures in DIVIDE function. Try if this can meet your need?

      Result = DIVIDE([Measure 1], [Measure 2])

       

      Best Regards,
      Community Support Team _ Jing
      If this post helps, please Accept it as Solution to help other members find it.