Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I've been tasked to create a matrix report showing Percent to Goal by Week by Location. My numerator value is # of Claims per Week. My denominator value is the Weekly Goal.
Without % to Goal calculation, I get a matrix like this, which works for my intent
However, when I create a measure- % to Goal by Week = DIVIDE([Count of First Sent],SUM('Goals by Week'[Daily Goal]))
I get unintended results- the percentages are in the hundreds or thousands
How do I correct my measure to give the correct calculation?
29 | 15 | 193%
57 | 65 | 87.6%
Etc.
Thank you
Hi,
The information there is not enough to solve the problem. Share the download link of the PBI file.