Forum Discussion
Slight % Calculation Error
Sorry I am not being clear.
I also left out the column 'quantity' in the previous tables.
I want to create another table or measure that allows me to have the same values in the 'Employee' column and leave out '0' in the 'theCode' column.
So I can have another table/measure that looks like below
| Month | Day | theCode | quantity | Employee |
| January | 26 | 131 | 774 | 13.36% |
| January | 26 | 132 | 146 | 2.52% |
| January | 26 | 51 | 104 | 1.80% |
| January | 26 | 77 | 20 | 0.35% |
| January | 27 | 131 | 1563 | 13.73% |
| January | 27 | 132 | 149 | 1.31% |
| January | 27 | 51 | 124 | 1.09% |
| January | 27 | 77 | 9 | 0.08% |
| January | 28 | 131 | 1222 | 14.86% |
| January | 28 | 132 | 76 | 0.92% |
| January | 28 | 51 | 8 | 0.10% |
Your FILTER() to exlcude the 0 code cannot exist if you want the results to be the same. Get rid of that filter. Just use ALL(TableName) for the filter, then filter the "0" codes out on a visual level filter in the filter pane. The calc should be the same because it will include the effect of the 0 code, but will exclude it from view.
If that doesn't work, please post a PBIX file. It would take someone a long time to key in all of that data and try and guess what your model is and what other filter contexts are in play to help future. You can easily share via OneDrive or DropBox. Just use fake non-confidential data.