Forum Discussion

aflintdepm's avatar
aflintdepm
Icon for Helper III rankHelper III
3 years ago

Percent to Goal by Week- Matrix Visual not calculating correctly

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

 

1 Reply

  • Hi,

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