Forum Discussion
Solved
Incorrect Row Subtotal when using coalesce
Hi all I'm trying to create a cash flow using the matrix visual. I have most things working except for subtotals - see below: As you can see the subtotals For the Cash Flow from O...
One approach is to use SUMX to iterate the dimension table that is used in matrix rows. Example measure:
CF Actuals with Correct Totals = SUMX ( VALUES ( DimTable[Column] ), [CF Actuals] )
One approach is to use SUMX to iterate the dimension table that is used in matrix rows. Example measure:
CF Actuals with Correct Totals =
SUMX ( VALUES ( DimTable[Column] ), [CF Actuals] )
Many thanks - that worked a treat.
It had me stumped so much that I was considering adding a specific cash flow FACT table.
Cheers
Jake