Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
101 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |