Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have two columns - 1. Total Points 2. Max Total Points How can I get a measure to get an average of points (total points / Max total points)
Solved! Go to Solution.
hi @jcastr02
You could use AVERAGEX Function to create a measure like below:
https://docs.microsoft.com/en-us/dax/averagex-function-dax
Regards,
Lin
hi @jcastr02
You could use AVERAGEX Function to create a measure like below:
https://docs.microsoft.com/en-us/dax/averagex-function-dax
Regards,
Lin
@v-lili6-msft I tried to do this, but when I put in visual in gave me error....here is sample data, not sure if this helps....I would want the score to show the roll up of the team members overall score (of all modules).....
hi @jcastr02
I hve test on my side, it works well.
here is my sample pbix file, please try it.
If possible, could you please share your sample pbix file and your expected output for us have a test?
Regards,
Lin
Disregard , this worked it was how my data type was set up, thanks so much! @v-lili6-msft
@v-lili6-msft If I use a line chart, the number tends to stay consistent, if I use a gauge chart, there is only that one roll up value, so it works...
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Can you share sample data and sample output. You can have the calculation like this
Calculate(Average(Table[Total Point]))
Calculate(divide(sum(Table[Total Pont]),sum(Table[max Point])))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
99 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
108 | |
104 | |
83 | |
73 |