Forum Discussion
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...
| Club Name | Agreement Number | Last Name | First Name | Membership Type | Profit Center | Payment Date | Payment Amount |
| Club Orchid | 2045 | Hernandez | Rab | BASE | Dues | 5/10/2023 | 5 |
| Club Rose | 4045 | Fernandez | Carlos | BASE | Late Fee | 5/10/2023 | 10 |
| Club Orchid | 4971 | Samuel | John | BASE | Dues | 5/24/2023 | 20 |
| Club Lily | 5522 | Jimenez | Eli | BASE | Processing Fee | 5/31/2023 | 5 |
| Club Rose | 6522 | Tran | Elizabeth | BASE | Dues | 5/31/2023 | 30 |
| Club Orchid | 9535 | Hobson | Lexi | PEAKPR | Annual Fee | 5/16/2023 | 5 |
| Club Lily | 8535 | Style | Harry | PEAKPR | Dues | 5/16/2023 | 10 |
| Club Orchid | 9806 | Minor | Eugie | PEAKPR | Dues | 5/19/2023 | 5 |
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.
