Forum Discussion
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?
1 Reply
- IdrissshatilaSuper 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