In matrix visual - I need sum in total field instead of average

[loki03]

I need the sum of the actual weighted KPI to be 58.15 and not 11.40. Is there a possibility to alter this?

[danextian · Accepted solution]

Hi @loki03 ,

Assuming that the granularity of the Actual Weighted KPI measure is based on the LookupValue column, you can create a virtual summary table of the items within that column plus the corresponding kpi and use SUMX to sum those kpi values. Measure would go like this:

=
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[LookupValue],
        "Actual Weighted KPI", [Actual Weighted KPI measure]
    ),
    [Actual Weighted KPI]
)

[v-zhangti · Accepted solution]

Hi, @loki03 

You can try the following methods.

Measure = IF(HASONEVALUE('Table'[LookupVlaue]),[Actual Weighted KPI],SUMX('Table',[Actual Weighted KPI]))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[danextian · Accepted solution]

Hi @loki03 ,

Assuming that the granularity of the Actual Weighted KPI measure is based on the LookupValue column, you can create a virtual summary table of the items within that column plus the corresponding kpi and use SUMX to sum those kpi values. Measure would go like this:

=
SUMX (
    SUMMARIZE (
        'Table',
        'Table'[LookupValue],
        "Actual Weighted KPI", [Actual Weighted KPI measure]
    ),
    [Actual Weighted KPI]
)