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)

3 Replies

    • perezco's avatar
      perezco
      Advocate III

      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

        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.