| | 2021 | | | | | | | | | | | | 2021 Total |
| Row Labels | January | February | March | April | May | June | July | August | September | October | November | December | |
| Company A | 45,064 | 45,664 | 66,988 | 79,499 | 93,733 | 62,808 | 65,191 | 84,753 | 55,461 | 61,761 | 42,569 | 56,936 | 3,000,000 |
| Company A Plan A | 14,969 | 15,168 | 22,251 | 26,407 | 31,135 | 20,863 | 21,654 | 28,152 | 18,422 | 20,515 | 14,140 | 18,912 | 2,000,000 |
| Company A Plan B | 30,095 | 30,496 | 44,737 | 53,092 | 62,598 | 41,945 | 43,537 | 56,601 | 37,039 | 41,246 | 28,429 | 38,024 | 1,000,000 |
Long story short, I am taking over a poorly written BI report. A matrix table is made based on the following Hierarchy: Company Name > Companies Plans. The values are coming from the measure [Totals] which is a long long long dax measure written because the model was set up poorly. The company Plan totals should sum up to the company total above, and it does. However, when summing it sums up to the year subtotal, it is not correct. I am wondering the quickest solution to this problem to get this report back online. I will be spending the next few weeks rebuilding the report, but stakeholders need it in the mean time.
Thanks.
