Forum Discussion
Trouble Calculating a Dynamic Average
Hi Anonymous ,
Create this measure.
Average Score = CALCULATE ([Score], ALLSELECTED('OST'))Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
It works fine through my tests. Can you provide sample pbix files (taking care to protect private data) for us to test?
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Neeko,
Please find a sample file here.
Please let me know if you have any troubles with access.
Thanks!
Maggie
Hi Anonymous ,
Create this measure.
Average Score = CALCULATE ([Score], ALLSELECTED('OST'))Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This worked! Thank you so much everyone for all of the assistance!
Hi there,
Thank you so much for the help on this. It appears that while that solution worked for that particular instance, I am having trouble applying correctly to another instance. As you see in the screenshot, the "total" is showing as 19, however, that is incorrect as the average should be closer to 9. Do you have any idea why this might be?
Appreciate any assistance here in advance. Thank you so much!
Hi Anonymous - just following up on the above. If you have any insight into this it would be greatly appreciated. Thank you!