Thank You for posting your query onto the Forum.
The sub-totals for the following categories which you’ve mentioned is showing blank because the context that you’re referring while calculating sub-totals for each category comes from two different tables i.e. “Cash Flow Data” as well as from “Cash Flow Template”.
So below is the below that you’ve written as follows -
Net Cash Flow - Operating Activities =
CALCULATE('Cash Flow Analysis'[Cash Flow Amount] ,
FILTER('Cash Flow' ,
'Cash Flow'[Cash Flow Category] = "Net cash inflow from operating activities" && -- Sub - Total line item not there in Cash Flow Data
'Cash Flow'[Cash Flow Type] = "Operating Activities" ) ) -- Only getting referenced is the Type from that
Cash Flow Data
Now, if you see in the above formula, you’ll observe that you don’t have any such line item in your “Cash Flow Data” under the “Category” column with the name as - “Net cash inflow from operating activities”. This line item is from “Cash Flow Template” and not from “Cash Flow Data”.
And while calculating the sub-totals for each of the categories you’ve referenced this two tables in all of your measures. Since this line item does not exists at all in your “Cash Flow Data” it’s showing you as blank.
Now, if you observe the “Financial Reporting” video as well as working of PBIX file provided by @sam.mckay you’ll see that he has calculated the sub-total for each categories and those line items exists under his categories.
For example -
Cash Paid For - Operations =
CALCULATE( [Cash Flow Values],
FILTER( 'Cash Flow Data',
'Cash Flow Data'[Cash Flow Category] = "Cash paid for" && -- This Line item exists under the Category column
'Cash Flow Data'[Cash Flow Type] = "Operations" ) ) -- The referenced table is also Cash Flow Data and not Template one
Below is the screenshot provided for the reference.
Now, if you see in your case, you’ve have the Cash Flow type as “Operations” but “Net cash inflow from operating activities” is not under the “Cash Flow Category” it’s under the Template and this has happened because while designing the data for Cash Flow this line item and all other line items which contains this type has been ignored from it. Once you add the following line items against which it’s showing you as blank you’ll see the figures against those line items.
I’m providing the working of @sam.mckay PBIX file of Cash Flow Statement for your reference which I’d used while practicing the Financial Reporting.
Hoping you find this useful and helps you in your analysis.
Thanks & Warm Regards,
Cash Flow Statement.pbix (876.3 KB)