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...
Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
| 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.