Measure gives wrong result? Running sales total divided by Rep Goal to get budget% achieved

[pete234]

=IFERROR([Sum Order Value]/[Sum of IND_Q],0)

I see values that make no sense like 0/0 = 1.8.
And I have values in my measuere where drill through is empty?
I've rechecked this many time so far and I can't tell why it isn't working.

Sum of Order Value is the sales total pivoted as Running total by week number.
This is working fine. I want to divide the RT by the expected goal, IND_Q a fixed value per rep from quota table.

IND_Q is from a table containing rows of quota goals by week by rep.

any ideas how can I achieve this goal?

 

[r1c1]

I think the problem is in your measure [Sum of IND_Q].

Create something like this in reps table,

rep quota:=min(reps[Quota])

(assuming your sales reps are reps table)

Then you can divide running total / rep quota (or even set up a KPI on running total with quota as target value).

 

[pete234]

You might be right but now I see the running totals aren't working.
So I will post again because I can't find anything that says this shouldn't work.

 

[powerpivotpro]

The usual offer here Pete: send me the workbook and I will help