Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |