Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |