Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Hi @sebastienke
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
@sebastienke , Have you check export summarized data in power bi service, and that gives the same issue?
@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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |