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