topic Re: Measured subtotals like disappear when date slicer is applied in DAX Commands and Tips

Measured subtotals like disappear when date slicer is applied

Cridezi — Tue, 15 Jul 2025 18:00:41 GMT

Hi everyone,

I'm building a financial statement in Power BI using a matrix visual. I have a measure called Actuals that uses SELECTEDVALUE(tbl_ChartofAccounts[Level 0]) to display values for base accounts (like "Revenue", "COGS") and calculated lines (like "Gross Margin", "EBITDA", etc.) via a SWITCH statement. (see below)

Actuals =

VAR Level0 = SELECTEDVALUE(tbl_ChartofAccounts[Level 0])

RETURN

SWITCH( TRUE(),

Level0 = "Gross Margin", [Gross Margin],

Level0 = "EBITDA", [EBITDA],

[ValuePL]

)

All values show correctly when no filters are applied (see snip below).

However, when I change the calendar slice (e.g., filter 2023-2024, my calculated sublines dissapear? See snip below. Could someone help what's going on?

Re: Measured subtotals like disappear when date slicer is applied

FBergamaschi — Tue, 15 Jul 2025 18:10:26 GMT

You need to write here the code of the two measures showing the issue

[Gross Margin],

[EBITDA]

otherwise it is impossible to help you

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Re: Measured subtotals like disappear when date slicer is applied

Cridezi — Tue, 15 Jul 2025 18:21:29 GMT

Gross Margin = [Revenue] + [Other operating income] + [Cost of goods sold]

EBITDA = [Gross Margin] + [Operating expenses]

Revenue and other FSLIs were calculated in the following way. These measured were created only to get the EBITDA, Gross margin calculated.

"Revenue =

CALCULATE(

[ValuePL],

FILTER(

ALL(tbl_ChartofAccounts),

tbl_ChartofAccounts[Level 0] = "Revenue"

)

Re: Measured subtotals like disappear when date slicer is applied

FBergamaschi — Tue, 15 Jul 2025 18:23:59 GMT

When you select specific years, those measures go to blank

I need to see the pbix to understand why, as the DAX yo showed brings to toher mesures and so forth

Can you share th epbix?

Re: Measured subtotals like disappear when date slicer is applied

Cridezi — Wed, 16 Jul 2025 04:48:02 GMT

The pbix contains confidential data, unfortunately I cant share... is there anything you would specifically need? (e.g if I take with snipping tool pictures?)

Re: Measured subtotals like disappear when date slicer is applied

v-pnaroju-msft — Wed, 16 Jul 2025 14:17:03 GMT

Thankyou, FBergamaschi, for your response.

Hi Cridezi,

We appreciate your question on the Microsoft Fabric Community Forum.

Based on my understanding of the issue, please find attached a screenshot and a sample PBIX file that may assist in resolving the matter:

We hope the information provided helps to resolve the issue.
Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.

Thank you.

Re: Measured subtotals like disappear when date slicer is applied

v-pnaroju-msft — Sat, 19 Jul 2025 17:24:10 GMT

Hi Cridezi,

We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

Re: Measured subtotals like disappear when date slicer is applied

v-pnaroju-msft — Tue, 22 Jul 2025 12:09:13 GMT

Hi Cridezi,

We are following up to see if the details we shared solved your issue.
If you need more support, feel free to contact the Microsoft Fabric community.

Thank you.

Re: Measured subtotals like disappear when date slicer is applied

v-pnaroju-msft — Fri, 25 Jul 2025 11:21:36 GMT

Hi Cridezi,

We just want to check if the information we gave has fixed your problem. If you need more help, please don’t hesitate to ask the Microsoft Fabric community.

Thank you.