Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Regular Visitor

Calculate Measure is not showing values when Page Filter is applied to matrix

I have a series of measures which attempt to sum various accounts in an Income Statement into sub-totals. So there is a measure for Total Income, one for Total Cogs, one for total overeheads etc. I then use a SWITCH TRUE to pull those measures into the columns on my Income Statement. measure which sums my sales accounts.


All is working great until I apply a company filter to the PowerBI visual. The Calculate measures for the subtotals disappear when I try to filter for one company and comes back when there is no company filter on. Anyone got any ideas? Whent he company filter is applied i can still see the values from the ME_P&L SUBTOTALS below but the values from the ME_TOTAL INCOME disappear.


The Calculate measure for Total Sales in the income statement is...

ME_TOTAL INCOME = CALCULATE([ME_Amount], 'P27 TOP generalLedgerAccounts'[accountNumber] > 39999 && 'P27 TOP generalLedgerAccounts'[accountNumber] < 50000)
The SWITCH TRUE measure to give the income statment is....
ME_P&L Subtotals =
VAR CurrentItem = SELECTEDVALUE('P27 TOP incomeStatements'[display])
CurrentItem = "Total Income",CALCULATE('Measures (2)'[ME_TOTAL INCOME],ALL('P27 TOP incomeStatements')),
CurrentItem = "Total Cost of Goods Sold",CALCULATE('Measures (2)'[ME_COGS],ALL('P27 TOP incomeStatements')),
CurrentItem = "Gross Profit",CALCULATE('Measures (2)'[ME_GROSSPROFIT],ALL('P27 TOP incomeStatements')),
CurrentItem = "Total Overheads",CALCULATE('Measures (2)'[ME_OVERHEADS],ALL('P27 TOP incomeStatements')),
CurrentItem = "Ebitda",CALCULATE('Measures (2)'[ME_EBITDA],ALL('P27 TOP incomeStatements')),
CurrentItem = "Operating Profit",CALCULATE('Measures (2)'[ME_OPERATINGPROFIT],ALL('P27 TOP incomeStatements')),
FILTER('P27 TOP incomeStatements', 'P27 TOP incomeStatements'[display] = CurrentItem)))

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors