Solved: Is this an aggregation issue?

jcampbell474 · ‎04-13-2020

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 · ‎04-13-2020

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.

View solution in original post

v-juanli-msft · ‎04-13-2020

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.