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...
It should count only dues agreement number not all. How do I do it?
How do I change Average Dues to $. Mine appeared as in decimal.
click on the measure in the field list and then in the top menu change the formatting.
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.