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.
Above mentioned visual contain a column which is calcualting average of value...Average calcualtion are correct...But Its row level subtotal showing is not correct....17.33+17.57=34.9 is neede...But showing like 17.36...Why it is happening like this..Any solution for this?
Solved! Go to Solution.
Hi, @NISHA_S
Please try the below.
Write one more measure like below.
Total Fix =
SUMX ( VALUES ( [System Type Column] ), [Your Avg Measure] )
And put the above measure into the visualization.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @NISHA_S
Please try the below.
Write one more measure like below.
Total Fix =
SUMX ( VALUES ( [System Type Column] ), [Your Avg Measure] )
And put the above measure into the visualization.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hello,
It is calculating the average on the total categorie of Concrete. It does not sum up the average...
The solution is to manually set up your totals with custom measures and to remove standard totals.
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |