Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 Operating Activities and Cash Flow from Financing Activities are incorrect.
The measures I'm using are:
Solved! Go to Solution.
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] )
Proud to be a Super User!
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] )
Proud to be a Super User!
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
Glad to hear that worked, and that you avoided creating an additional fact table. 🙂
Proud to be a Super User!