Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Matrix subtotal 100 for porcentage

Hi
I have a meassure that gives me the porentage like this 

[SumFacturado]/[SumFacturadoTotal]
I use it on a matrix.
Now only my total is 100% when no column is expanded, what I need is that always the subtotals by 100% beacuse columns are herarchicals.
Can someone help me please?

Thanks!
3 REPLIES 3
Anonymous
Not applicable

Hello

I would like to know if you got the answer for your question, I have the same issue and I would like to know

v-danhe-msft
Employee
Employee

Hi @Anonymous ,

It seemed work on my side, could you please offer me a sample file to have a test if possible?

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi,
Thanks for answering.
I can add a picture for you.
First I do not why I do not reach the 100% even when is full compress, as you see I have a TOTAL 98,26% .
The second and more important for my, is that when I OPEN in One level I see that SUBTOTAL is 34.51% of HC. What I want is a subtotal of 100% allways.
Dependeding of the expanding  column I have to have the 100%

thanks in advance!
powerbi.jpg

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.