Roundup Measure not summing correctly across matrix rows and columns

[Anonymous]

I need help. 

I am trying to use a measure with roundup for multiple territories over the course of different months. The values within the matrix are calculating correctly, but I can't get the row totals and column totals to total the correct amounts. I have looked through multiple posts and when I fix one issue it breaks another. 

Here is the measure I used to calculate the monthly quota by territory based on the previous 6 months of data. I am not sure if this is where the problem lies if I need to add logic to calculate at the territory level here.

Quota =

     Roundup(CALCULATE('MT Quota'[Baseline],all(Quota[Order Date]),

DATESBETWEEN('Calendar'[DATE],[QuotaStartDate],[QuotaEndDate]))/6,0)

Here is the measure I used to try and fix the row and column totals (unsuccessfully). 

Test =

     VAR _Test =

          SUMMARIZE(Quota,Quota[Sales Territory],"_value",[Quota])

          Return

               if(HASONEVALUE(Quota[Sales Territory]),

               [Quota],

               SUMX(_Test,[_value])

               )

PBIX and sample file located here:

https://docs.google.com/spreadsheets/d/1VpvfehhXeyaqPPQ6AySdmc3Kn1-dhyzO/edit?usp=sharing&ouid=11539...

Any help is appreciated! 

[tamerj1]

Hi @Anonymous 

There in no PBIX file in the link

[Anonymous]

Apologize. Here is the link to the PBIX

https://drive.google.com/file/d/10Hc3NZqIl7yqWjd0Jc5krjtfi8r8atNr/view?usp=sharing

[tamerj1 · Accepted solution]

@Anonymous 
Please refer to attached sample file with the solution