cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Regular Visitor

## 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 11
Super User

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-...
Please show the expected outcome based on the sample data you provided.

Regular Visitor
 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
Regular Visitor

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.

Super User

Are you sure about that calculation?

Regular Visitor

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

Super User

Regular Visitor

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

Super User

click on the measure in the field list and then in the top menu change the formatting.

Regular Visitor

Thank you. I guess your formula is taking all the payment amount. It should be Average Dues= Payment Amount (Only of Dues not others) / Agreement Number (Only Dues). It's giving me incorrect average dues.

Super User

Please show the expected outcome based on the sample data you provided.

Regular Visitor
 Club Name Agreement Number Profit Center Payment Amount Club Daisy 1231 Dues 15.99 Club Lily 8952 Annual 49.99 Club Marigold 4582 Processing Fee 1.99 Club Orchid 8962 Dues 15.99 Club Rose 4562 Annual 49.99 Club Daisy 7862 Processing Fee 1.99 Club Lily 3252 Dues 15.99 Club Marigold 4562 Dues 15.99 Club Orchid 8232 Annual 49.99 Club Rose 1232 Processing Fee 1.99 Club Daisy 8342 Dues 15.99 Club Lily 2312 Dues 15.99 Club Marigold 4252 Dues 15.99

Here, I want to create a measure that calculates the Average Dues.
For example: Here we have 7 Members that have Profit Center as Dues.
Now, If I calculate Average Dues for Just Club Daisy. It would be Average Dues = Payment Amount (15.99 +15.99) /2 (There are 2 members in Club Daisy that has Dues). Now the Average Dues would be 31.98/2, which is \$15.99. So, the Average Dues for Club Daisy is \$15.99.
In same way, I want to calculate Average dues for all the other clubs and create a matrix visualization that displays club names and their average dues.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

#### Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors