How to Calculate Sum in Grand Total instead of taking Automatic function

[Sowdeswari]

We are migrating the report from Tableau to Power BI. In Tableau we could see the function like Sum, Automatic etc. for the Grand total. But the Similar function is not available in Power BI. Need a help to do Sum in Grand Total instead of taking Automatic function.

Tableau:

Power BI :

Calculation used for this coulmn:

Additional Cost due to Expedite (Kgs) = IF([Standard Kgs]=BLANK(),BLANK(),[Expedited Kgs]* 'shp_data'[Delta in Expedite & Standard Cost per Kg])

The Grand total should take the Sum of this column instead using the above calculation.

[Akash_Varuna · Accepted solution]

Hi @Sowdeswari You could go for a measure which overrides this 

• Define a custom measure for the sum:

  Additional Cost Total = IF( ISINSCOPE('Table'[RowIdentifier]), [Additional Cost due to Expedite (Kgs)], SUMX('Table', [Expedited Kgs] * 'shp_data'[Delta in Expedite & Standard Cost per Kg]) )

• Use this measure in your visual: Replace your existing measure with this custom measure, and the Grand Total will display the sum.