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.
Solved! Go to Solution.
Apologize. Here is the link to the PBIX
https://drive.google.com/file/d/10Hc3NZqIl7yqWjd0Jc5krjtfi8r8atNr/view?usp=sharing