cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

column subtotals not showing up in matrix visual

Hello everyone! I'm having this issue where I have a matrix with a measure on value, and date field in column and another dimension on rows. Although the column subtotals are turned on, the subtotals column won't actually show up on my matrix. For some reason it shows up as expected when dates are sliced on the date slicer but ONLY when dates are sliced. Any help would be greatly appreciated! I've attatched some pictures for more clarification too.

 

Annotation 2020-05-29 143627.pngAnnotation 2020-05-29 150944.pngAnnotation 2020-05-29 150223.png

I can't scroll any farther to the right, but hypothetically I should be able to to see the totals. 2/14 to 5/23 are full dates
Annotation 2020-05-29 152133.pngAnnotation 2020-05-29 151014.png 

 

It's only when I slice the dates does it actually show up. 

 

Thank you again for your help!

5 REPLIES 5
Highlighted
Super User III
Super User III

Re: column subtotals not showing up in matrix visual

Hey @purplefawn ,

 

did you check if the measure contains some DAX like this:

if(isfiltered('<tablename>'[columnname])
    , sum('<othertablename>'[othercolumnnam2])
    , blank()
)

If the column is not filtered the DAX statement will return BLANK().

Please consider sharing the DAX statement you are using inside the visual.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Highlighted
Community Support
Community Support

Re: column subtotals not showing up in matrix visual

Hi @purplefawn 

As tested, it shows column total on my side.

Could you share me more information so to solve this problem?

For example, what columns/measures are added into matrix buckets (value, row, column)?

are they from the same table or different table?

a simple data example for test?

 

Best Regards

Maggie

Highlighted
Frequent Visitor

Re: column subtotals not showing up in matrix visual

Thank you @TomMartens  and @v-juanli-msft for taking the time to help. 
The measure is 

 

Measure = DISTINCTCOUNT('mytable'[person])

 

The column used in the DAX is a second text field in the table: 

Row is a categorical text field: Hometown

Date field is a date with type date: 9/15/2018

Everything is native to one table

 

 

Highlighted
Super User III
Super User III

Re: column subtotals not showing up in matrix visual

Hey @purplefawn ,

 

can you share the pbix?

If not create a pbix that contains sample data, but still reflects your data model. Upload the file to onedrive or dropbox and share the link. If you are using an Excel file to create the sample data, share the xlsx as well.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Highlighted
Community Support
Community Support

Re: column subtotals not showing up in matrix visual

Hi @purplefawn 

I can't reproduce your problem, could you check if you update to the last version?

Capture4.JPGCapture5.JPG

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Super Users of the Quarter - Q2 2020

Super Users of the Quarter - Q2 2020

Who are our Super User Superstars? Who made it to the top of the leaderboards? Get the answers!

June 2020 Community Highlights

June 2020 Community Highlights

Featured community members, changes to the Community, and more! Read up on recent Power BI community news.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Kudoed Authors