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 different source of revenue.
3rd, I have the profit Center's Revenue Amount.
4th, I also have a column called Members (It has list of Members's agreement Number)
I want to simply calculate Average Dues (Just for 1 profit Center). I am assuming we have to use filter for it.
The formula to calculate Average dues = Dues Amount/Total Members .
Thank you
11 Replies
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/1447523Club 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.
