how to extract data from a matrix for all level in hierarchy

[Anonymous]

Hi PWBI community,

I think I have a problem well-known, but I didnt find a clear answer...
I have a matrice with different levels :

level 1	level 2	data
A		X
	a	12
	b	10
	c	3

X is the result of a complex equation based on data of level 2 (combined with other data).

If I extract a csv file from this matrix, i will have :

level 1	level 2	data
A	a	25
A	b	12
A	c	10

but My X has dissapear and I don't want to calculate it again in my excel file.

Any idea how I can extract data for level 1 ?

Thanks for your help

[v-jingzhang]

Hi @Anonymous 

Did you create a measure to change the subtotal calculation for level 1? Do you mean you want to export the data which is currently shown in the matrix visual?

Based on my test, I couldn't export additional lines for Level 1 with subtotal values either. Actually, the exported data is always the same no matter whether I include the subtotal values in the matrix visual or not. 

Regards,
Community Support Team _ Jing

[amitchandak]

@Anonymous , Have you check export summarized data in power bi service, and that gives the same issue?

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#export-summarized-data

[Anonymous]

@amitchandak thanks for you r quick answer, but yes i tried and the result is the same that when I extract from power bi desktop.