Forum Discussion
DAX- Calculating Average
| 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.
Thank you.
1 Reply
You don't need DAX or a matrix for that
Maybe adjust your sample data a bit to make it more interesting?
