Sum on the Average calculated measure is not Working.

[vskreddy46]

Hi Team,

As we are Migrating the Dasboard reports from qlik View to PowerBI. Qlik View have ability to do the Grand total values as follows 

SUM\AVG\% values at the Totals Mode Section in Qlik View. But in PowerBi is not Availble with This option.

Can any one has the Idea how we can over come from this. because My client is Asking for this.

Thanks all.

[v-haibl-msft · Accepted solution]

@vskreddy46

Does above solution help?

Best Regards,
Herbert

[v-haibl-msft]

@vskreddy46

I'm not sure what is your expected visual, but we can use DAX measure to do SUM on the Average like below.

SUM_On_Average_Year_Measure_2 = 
SUMX (
    VALUES ( Table1[Year] ),
    CALCULATE ( AVERAGE ( Table1[Sales] ), ALLEXCEPT ( Table1, Table1[Year] ) )
)

SUM_On_Average_Year_Measure = 
SUMX (
    ALL ( Table1[Year] ),
    CALCULATE ( AVERAGE ( Table1[Sales] ), ALLEXCEPT ( Table1, Table1[Year] ) )
)

Best Regards,
Herbert