Is this an aggregation issue?

[jcampbell474]

I've been encountering an issue with overall matrix averages not matching card averages.  In Qlikview, it was an aggregation issue...that was relatively simple to fix using this syntax: avg(aggr(sum(Total <UserId,cReportGroup,FiscalYearMonth> SalaryxMin),UserId,cReportGroup,FiscalYearMonth)) Total ignored the dimension(s) and manual aggregation was achieved at the end of the expression.  

Measure = Averagex(CRM_SalesRep,SUM(GMQuote[Actual Quotes]) / SUM(CRM_SalesRep[Total Calls]))

Can anyone help me understand what it happening, why the two results are different?

[v-juanli-msft · Accepted solution]

Hi @jcampbell474 

As tested, the card show the total of the matrix.

Measure = AVERAGEX(Table1,SUM(Table2[value2])/SUM(Table1[value1]))

If you have different scenario, please show me screenshots and your expected result.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.