Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
digialternative
Frequent Visitor

Switch function in Matrix not showing value's

Hello Experts,

 

I am experiencing some strange behavior of the Switch function in a matrix.

I am building a Cashflow statement report, and use a table for the rows (Level 1 and Level 2 names)

For the indiviual values I use Measures.

Via the Switch function, I place the correct Measures in the table at the position of the Level 1 and Level 2 items.

The strange things is that this works perfect for 99% of the items in the Switch table, but for the example below, I cannot get the value to display in the table (item [saldo liquide middelen]). The Switch itself works fine, as can be seen below. When I put a value of 1 in the Switch table for "saldo liquide middelen", the 1 is shown at the correct line in the report.... 

dashboard6.png

 

but when I put the Measure into this Switch table, the values remain blank.

dashboard7.png

 

When I create a new Matrix, using the same Level 1, Level 2, date selection and only the value for [saldo liquide middelen], I get the data displayed, but the Level 1 row name is "blank".

dashboard8.png

I can not understand what I am doing differently for this calculation that it act's differently than all other calculations that I place in the table via Measures...

 

The Measure itself (that works, as can be shown above) is as follows:

saldo liquide middelen =
CALCULATE(
    [Balans SUM],
    'Balans_Rapport'[Level 1] = "liquide middelen",
    FILTER(
        ALL(Datum),
        Datum[Datum] <= MAX(Datum[Datum])
    )
)
 
Somebody has a clue?
0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.