Data Download of underlying data giving more rows than what i see on Visual

[Anonymous]

Dear Team,

Data download is the big challenge on Power bI, here is the below matrix I have, I apply a few slicers and two visual level filters. but when I download data, as per image number 2, this is what I get, which is way more rows and the data is also different. 

Calculation I have on (They both are measure, as column does not work)

Check 1 = 

IF( ([ZF_PM-7] - [ZF_PM-6]) + ([ZF_PM-6]- [ZF_PM-5]) + ([ZF_PM-5]- [ZF_PM-4])+ ([ZF_PM-4]- [ZF_PM-3])+ ([ZF_PM-3]- [ZF_PM-2]) +([ZF_PM-2]- [ZF_PM-1] ) + ([ZF_PM-1]- [ZF_PM]) + ([ZF_PM]- [ZF_CM]) <= 0, "Ok", "Check")

 Check 2=

IF( ([ZF_PM-7] - [ZF_PM-6]) + ([ZF_PM-6]- [ZF_PM-5]) + ([ZF_PM-5]- [ZF_PM-4])+ ([ZF_PM-4]- [ZF_PM-3])+ ([ZF_PM-3]- [ZF_PM-2]) +([ZF_PM-2]- [ZF_PM-1] ) + ([ZF_PM-1]- [ZF_PM]) + ([ZF_PM]- [ZF_CM]) >

( (ABS([RecValue(12)])) + (ABS([FMTIn(12)])) +(ABS([FMTout(12)]))+ (ABS([IssValue(12)])) + (ABS([AjdValueN(12)]))+(ABS([AjdValueP(12)]) )+1) , "Check", "OK")

Visual -: Matrix

Data Download excel-

it's way different and wrong from my matrix.

I don't why its stuck on Month number 9, which is ZF_PM-7 since Current month is June.

Please advice.

[v-yuta-msft · Accepted solution]

@Anonymous ,

So your requirement is to export summarized data, not underlying data, right? Currently in power bi desktop we can export the summarized data as the visual shows. As a workaround, I would suggest you to publish your report to power bi service and then export the summarized data.

 

Community Support Team _ Jimmy Tao

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