Measured subtotals like disappear when date slicer is applied

[Cridezi]

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? 

[v-pnaroju-msft]

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.

[v-pnaroju-msft]

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.

[v-pnaroju-msft]

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.

[v-pnaroju-msft · Accepted solution]

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.

[Cridezi]

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?)

[FBergamaschi]

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

[Cridezi]

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"

        )

)"

[FBergamaschi]

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?