Forum Discussion

jcampbell474's avatar
jcampbell474
Helper IV
6 years ago
Solved

Is this an aggregation issue?

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(...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

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.