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
WilfredMeyboom
Frequent Visitor

Adding measure to matrix which doesn't get sliced

Hi all,

 

I'm trying to create a matrix in which the user can see a measure per month for a running year with a total column, combined with a column that shows the year to date total. Something like this:

 

image.png

 

 

 

I have created the measure for running year, which works as intended. And I can create a measure for the YTD calculation but when I add that to the matrix it get sliced automatically which I don't want. Hiding extra columns is not really an option since the user will export the matrix to excel and doesn't want to have any extra columns show up there.

Is there a way to tell the matrix it should slice one measure but not the other?

 

Any suggestions and / or other solutions are appreciated.

 

 

 

2 REPLIES 2
PaulDBrown
Community Champion
Community Champion

@WilfredMeyboom 

 

You can try this measure:
Total YTD = IF(ISINSCOPE(Table[YearMonth]), BLANK(), [Total YTD])

 

The columns will still be there (though you can reduce their width) but there will be no values displayed





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






It's a nice trick but won't the columns also show up in the export?

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.