Roundup Measure not summing correctly across matrix rows and columns

Anonymous — Wed, 26 Oct 2022 18:14:41 GMT

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=115391681889902948785&rtpof=true&sd=true

Any help is appreciated!

Re: Roundup Measure not summing correctly across matrix rows and columns

tamerj1 — Wed, 26 Oct 2022 18:47:30 GMT

Hi Anonymous

There in no PBIX file in the link

Re: Roundup Measure not summing correctly across matrix rows and columns

Anonymous — Wed, 26 Oct 2022 19:01:05 GMT

Apologize. Here is the link to the PBIX

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

Re: Roundup Measure not summing correctly across matrix rows and columns

tamerj1 — Wed, 26 Oct 2022 19:22:11 GMT

Anonymous
Please refer to attached sample file with the solution

topic Roundup Measure not summing correctly across matrix rows and columns in DAX Commands and Tips

Roundup Measure not summing correctly across matrix rows and columns

Re: Roundup Measure not summing correctly across matrix rows and columns

Re: Roundup Measure not summing correctly across matrix rows and columns

Re: Roundup Measure not summing correctly across matrix rows and columns