Forum Discussion
Measure giving different value from table total
Anonymous , That is strange. Please share the measure calculation.
Make sure no row is selected/clicked in the table and there is no visual level filter
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Table 1:
| JOB CODE | PLANNED HRS | START DATE | END DATE |
| 1 | 35 | 20/01/2023 | 31/01/2023 |
| 2 | 35 | 21/01/2023 | 31/01/2023 |
| 3 | 35 | 21/01/2023 | 31/01/2023 |
| 4 | 35 | 25/01/2023 | 31/01/2023 |
Table 2:
| JOB CODE | SECTION | ACTUAL HRS | STOP DATE |
| 1 | A | 4 | 22/01/2023 |
| 1 | A | 6 | 23/01/2023 |
| 1 | B | 10 | 23/01/2023 |
| 1 | B | 11 | 24/01/2023 |
| 2 | A | 2 | 22/01/2023 |
| 2 | A | 5 | 23/01/2023 |
| 2 | B | 9 | 23/01/2023 |
| 2 | B | 13 | 24/01/2023 |
| 3 | A | 3 | 22/01/2023 |
| 3 | A | 6 | 23/01/2023 |
| 3 | B | 12 | 23/01/2023 |
| 3 | B | 11 | 24/01/2023 |
I have put together a sample which is similar to what I'm using. The data is coming from a direct query (table 2) and excel sharepoint (table 1). Measure 4 is only a sum of all different sections for a job. So for Job 1, Measure 4 is 31.
Since table 1 is a sort of unique job code table, I've related table 1 and 2 through "JOB CODE". Then I've related table 1 by connecting "END DATE" with my calendar table. My reasoning was that due to the nature of table 2 having different dates allocated to a job code, relating the table 1 instead which has a single date allocated instead to "group" all data to a single date. Lastly the filters I have on the actual visuals are the following: