Forum Discussion

101's avatar
101
Regular Visitor
2 years ago

Dax- Calculation Help

Hello World, I need to calculate the Average Dues. Here, I have a Column called Clubs (It has name of all the clubs). 2nd, I have a column called Profit Center which compromises of our...
101's avatar
101
Regular Visitor
2 years ago

I want to create a measure, that gives me average dues for each club. The formula to calculate Average dues = Dues Amount/Total Members . Here, in the sample data, the total Memberes would be 8. 

lbendlin's avatar
lbendlin
Super User
2 years ago

Are you sure about that calculation?

 

 

  • 101's avatar
    101
    Regular Visitor
    2 years ago

    It should count only dues agreement number not all. How do I do it?

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

       

      • 101's avatar
        101
        Regular Visitor
        2 years ago

        How do I change Average Dues to $. Mine appeared as in decimal.