Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Fabric_Softener
New Member

Matrix Visual - Include value in grid and column total but not in row total

I can't imagine that what I'm trying to achieve is actually possible but I'm working with a matrix table and I need to achieve the following:

  • Include a value in the grid

  • Include the value in column totals

  • Exclude the value from all row totals

Like this:

 
Screenshot 2024-02-15 at 08.37.16.png
 

I've managed to include the value in the grid and exclude from all sub and grand totals so far, but I need it in the Column Grand Total. This is what I have so far

 

Screenshot 2024-02-15 at 08.35.19.png

 

This is the measure I used to get where I am so far:

 

IF(HASONEVALUE(Master[Act/FC]),SUM(Master[Act/FC]),CALCULATE(SUM(Master[Act/FC]),FILTER(Master,Master[Flow_Type]<>"Signed")))

 

Anyone have any idea how I can get closer to what I'm after?

 

 

1 REPLY 1
Idrissshatila
Super User
Super User

Hello @Fabric_Softener ,

 

to exclude the values from the totals, you need to use the is inscope dax function alongside with if.

 

check this https://youtu.be/Nd1jP9C8ZvQ?si=rExfOiUAFZmN6zVw

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors