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.
Hello All,
I could use some help with my percent measure not calculating correctly. My measure is the 3rd column divided by 4th column. Both columns are measures. If you divide 1 / 6 you get 16.17% but I get 18.18%. Also, the total should be 1 / 31 and 3.23% but I get 3.28%. I've had trouble with understanding why Power BI works like this but any help would be greatly appreciated.
Thanks!
Solved! Go to Solution.
Even though you changed the format, the value of your Measures are still decimal numbers.
You can change the value by using a DAX ROUND (or Roundup, Rounddown ) function to generate whole numbers if that is what you truly want your Measures to reflect
Are you sure the values in your 3rd and 4th columns are exact and are not rounded up?
1/5.5 = 18.18% or 1.0908 / 6 = 18.18% ?
Even though you changed the format, the value of your Measures are still decimal numbers.
You can change the value by using a DAX ROUND (or Roundup, Rounddown ) function to generate whole numbers if that is what you truly want your Measures to reflect
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |