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.
Good morning team,
For some reson when I have some rows with zero value in the column PEHQTY, the PROQTY doesn't sum the number associate with that row. It doesn't actually even show up in the visual. When I look to the data as a table, not the query, just the table, I can see the missing rows but I tried everything and nothing. It looks a simple solution, but I'm being able to close this one.
Here is the data.
Appreciate the help.
Kind Regards
Leo
Hi @Anonymous
you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive for business and share the link to the file. Please do not forget to describe the expected results based on this sample data.
Tough to tell. This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
If not, 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
Greg, good morning.
Thanks for the quick reply. If you see on the columns the only thing I did was to the show them as a sum. There is no measure done on these table specifically, that's why I don't understand why the zeros are being missed. I tried to change the format, but nothing seems to add the zeroes rows to the PROQTY.
Kind Regards
Leo
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 |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |