Table Column showing same value for all rows

[thefish]

I have a table being created for a control chart dashboard. It should show customer and the number of days out of control for our KPI. However, while the value is correct when not put in the table, it won't change for the customers in the rows. 

For example

KPI = 3

customer:    KPI

c1                       3

c2                       3

c3                       3

How do I solve this

[dplr-rn]

it depends on the expression. Share that please

[thefish]

AVG(total {<[Date]={(Date Selection here}>} AGGR({<[ Date]={(Date Selection Here)}>} $(vKPI), ([Date],[Customer])))

Table has the dimension customer and 2-3 other measures which work perfectly 

vKPI is an IF Statement which is the sum of various other metrics. It has it's own set analysis. 

This is supposed to return the average of the KPI for the customer. 

[dplr-rn]

Most likely cause is the total 

total keyword ignores dimensions. try removing that.

hope that works else you may need to rewrite the expression

[thefish]

When I remove total, it only shows values for 3 of the 50+ customers... 

Possibly due to NULL Days?

[dplr-rn]

You mean date is null?

Check the requirements. Do you need the aggr function in your chart

[thefish]

I mean not every customer has data for each day. 

And yes the AGGR is necessary. 

[dplr-rn]

Share what the  other dimensions are 

[thefish]

There are no more in the table.