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

[Fabric_Softener]

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:

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

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?

[Idrissshatila]

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