Forum Discussion

101's avatar
101
Regular Visitor
2 years ago

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...
101's avatar
101
Regular Visitor
2 years ago

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

lbendlin's avatar
lbendlin
Super User
2 years ago

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

 

  • 101's avatar
    101
    Regular Visitor
    2 years ago

    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. 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Please provide sample data that fully covers your issue.
    Please show the expected outcome based on the sample data you provided.

  • 101's avatar
    101
    Regular Visitor
    2 years ago
    Club NameAgreement NumberProfit CenterPayment Amount
    Club Daisy1231Dues15.99
    Club Lily8952Annual49.99
    Club Marigold4582Processing Fee1.99
    Club Orchid8962Dues15.99
    Club Rose4562Annual49.99
    Club Daisy7862Processing Fee1.99
    Club Lily3252Dues15.99
    Club Marigold4562Dues15.99
    Club Orchid8232Annual49.99
    Club Rose1232Processing Fee1.99
    Club Daisy8342Dues15.99
    Club Lily2312Dues15.99
    Club Marigold4252Dues15.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.