Forum Discussion
Slight % Calculation Error
It is hard to see exactly what is going on because your measures references columns we cannot see and I don't know how your model looks. You are using ALLSELECTED too but I don't know how as there are no slicers or anything else showing how selection is working.
That said, your v1 measure is saying:
Divide the Sum of the ATB Quantity in this filter context by the Sum of the ATB Quantity for all selectect records where the theDate = the Max value of theDate.
Your V2 measure is saying:
Divide the Sum of the ATB Quantity in this filter context by the Sum of the ATB Quantity for selected records but exclude any quantities where theCode <> 0.
If there are any quanties for records where theCode <> 0, then your divisor will be different (and it obviously is) so you should get a different answer.
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.