Matrix Preview Total Row export

[digant]

Hi,

I have added measue to calculate Gross Revenue Per Million as Gross Revenue / Total Volume * 1000000.

Below measure works fine in power BI for detail rows as well as for Grand Total however export to excel just shows Total, which is incorrect.

I used below measure 

SGPPMAUD = DIVIDE(SUM(ProfitabilityDetails[StandardGrossProfitAUD]),SUM(ProfitabilityDetails[VolumeAUD]),0) * 1000000

 Is there a way, I can have same value what has been shown in power BI when I am exporting to Excel ? 

regards,

Digant

[digant]

[Anonymous]

Hi @digant,

Can you provide some sample data to test? It will be help for troubleshooting.

Regards,
Xiaoxin Sheng