Forum Discussion

perezco's avatar
perezco
Icon for Advocate III rankAdvocate 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

3 Replies

    • perezco's avatar
      perezco
      Icon for Advocate III rankAdvocate 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
        Icon for Community Support rankCommunity 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.