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
Zarlot531
Helper V
Helper V

Displaying a measure only as Grand Total

Is there a way to show a given measure only as a Grand Total? 

1 ACCEPTED SOLUTION
v-cherch-msft
Employee
Employee

Hi @Zarlot531 

I would suggest you may use ISFILTERED function.

Reference:https://powerpivotpro.com/2013/03/isfiltered-a-better-way-to-detect-totals/

Measure 2 = IF(ISFILTERED(Table[column]),Blank(),[Measure])

Regards,

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

View solution in original post

2 REPLIES 2
v-cherch-msft
Employee
Employee

Hi @Zarlot531 

I would suggest you may use ISFILTERED function.

Reference:https://powerpivotpro.com/2013/03/isfiltered-a-better-way-to-detect-totals/

Measure 2 = IF(ISFILTERED(Table[column]),Blank(),[Measure])

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jdbuchanan71
Super User
Super User

Hello @Zarlot531 ,

You should be able to use 

IF ( ISSUBTOTAL ( table[column]), [measure], BLANK() )

You will juse need reference one of the columns visable in your matrix.

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.