cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

No Subtotals in matrix

Hi,

 

I am new on Power BI and trying to create an matrix report but acutally I am fighting with following problem:

 

I have a customer field with two levels or sub categories. 

When I only show the level 1 data a see values on each level 1 data and when I expand to level 2 I only see values each level 2 data. At this moment I am missing values on each level 1 data but I need them because they are sum of the level 2 values.

 

I know I could also solve this with the subtotal function but this doesn't work I don't know why.

The measure has an calculator icon and the source is an connecting with an Olap Cube.

 

I don't know what to do.

Best regards,

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: No Subtotals in matrix

Hi @Anonymous,

 

Did you turn the option "Row subtotal" on in Format? Based on my test, seemed that everyting worked well.

Capture.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Highlighted
Anonymous
Not applicable

Re: No Subtotals in matrix

Hi @v-frfei-msft

 

thank you for your answer.

 

In settings the option row subtotals is also ON.

Is it maybe because of the measure(type)? The icon next do measure is an calculator?

Because when i try it with an excel file it works but I am conncted with an olap. 

 

Unbenannt.JPG

 

Best regards

 

 

Highlighted
Community Support
Community Support

Re: No Subtotals in matrix

Hi @Anonymous,

 

I tested it using measure. It worked well all the same. Could you please tell me what is your formula? Or kindly share your pbix to me if you have no confidential data? Please upload your file to One Drive and share the link here.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors