Forum Discussion

Fabric_Softener's avatar
Fabric_Softener
New Member
2 years ago

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:

 
 

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?