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

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
Anonymous
Not applicable

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

 

 

Hi @Anonymous 

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.

Hey @Anonymous ,

 

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
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

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

TomMartens
Super User
Super User

Hey @Anonymous ,

 

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

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.