Exporting summarized data does not include lines where the measure is the same as the previous line

[sg1234]

Reposted here as I think I originally posted it in the wrong section (Report Server).  Sorry!

Hi, 

I hope you can help me with my problem please.  I have a matrix that displays a caluclated measure in Power BI.  The measure is calculated usinng a number of variables and is cumulative over a period.  So for example if there is nothing to add on in the second period, the total will be the same as the previous period.  The measure works well and is displayed as expected in a matrix in a Power BI Server report and looks like the below.  The bold rows are totals.  And for example the highlighted blue row has 

0 in Period 1, 

18,000 in Period 2, 

nothing happens in Period 3, so the total is still 18,000 

78,000 in Period 4 and Period 5

and then 38,000 in Period 6

This is all as expected.  The problem is when one of my users wants to export this in as summarized data, neither the zero rows or the duplicate 18,000 row is included in the data (for the blue highlighted row).  You can see from the screenshot below that not all periods are exported.

Is there a away to change this please?  My users like to export the data in table format and so they use the Summarized Data option when exporting.  If they export using Data With Current Layout, it is not in a very user friendly format for them as they like to pivot the data in Excel etc.

Many thanks for your help.

Sarah

[v-yueyunzh-msft · Accepted solution]

Hi , @sg1234 

According to your description, you use a measure to get the rolling sum of the value per period and you export it to excel/csv in Power BI Service.

And you find that the same value and 0 do not display in the excel .

I test it in my side , this is my test data:

And i create a measure to test:

And when i export it to excel , the data is all display :

What I want to say is that the export of Power Bi Service is the default behavior, and we have no place to modify the export result of this behavior.

And in my test, I exported the corresponding data, and I don't know how you achieve your Measure. If I need me to help you test, you can use your Sample PBix (delete sensitive data).

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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