Percent to Goal by Week- Matrix Visual not calculating correctly

[aflintdepm]

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

[Ashish_Mathur]

Hi,

The information there is not enough to solve the problem.  Share the download link of the PBI file.