cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## Power BI Matrix one sum stays blank. Why?

Hi, I use to work with data from two different reporting dates in my data model based on the underlying data structure in our database. I have implemented a logic which takes 2023 delivery volumes from report date 31.12.2023 (as this data will not be 100% available in latest report date) and latest report date for >= 2024 deliveries. Here is how it looks in Excel and should be look in PBI as well:

For some reason, the highlighted sum is not shown in PBI. All the other sums and the detail rows are shown correctly.

Any idea whats wrong here?

I have tried several formulas but non of them fixed this issue.

Formula at the moment:

It is basically a SUMX SUMMARIZE function which sums up the Meassure "Abs_VOLUME" where I put in all the columns I use to filter or to detail the visulisation in the first part of the formula.

BR
Nils

1 ACCEPTED SOLUTION
Community Support

For your question, here is the method I provided:

The presentation of data in power bi and excel will be different, the style in your screenshot may not be possible, but I have another way for your reference.

Here's some dummy data

“Table”

Create a new table.

``````Table 2 =
UNION(
SELECTCOLUMNS(
'Table',
"type", 'Table'[type],
"type_pay", 'Table'[type_pay],
"year", 'Table'[year],
"value",SWITCH(TRUE(), 'Table'[year] = 2023, 'Table'[value], 'Table'[year] <> 2023, 0)),
SELECTCOLUMNS(
'Table',
"type", "_" & 'Table'[type],
"type_pay", 'Table'[type_pay],
"year", 'Table'[year],
"value",SWITCH(TRUE(), 'Table'[year] = 2023, BLANK(), 'Table'[year] <> 2023, 'Table'[value]))
)``````

You can get the table like this.

Create a matrix.

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support

For your question, here is the method I provided:

The presentation of data in power bi and excel will be different, the style in your screenshot may not be possible, but I have another way for your reference.

Here's some dummy data

“Table”

Create a new table.

``````Table 2 =
UNION(
SELECTCOLUMNS(
'Table',
"type", 'Table'[type],
"type_pay", 'Table'[type_pay],
"year", 'Table'[year],
"value",SWITCH(TRUE(), 'Table'[year] = 2023, 'Table'[value], 'Table'[year] <> 2023, 0)),
SELECTCOLUMNS(
'Table',
"type", "_" & 'Table'[type],
"type_pay", 'Table'[type_pay],
"year", 'Table'[year],
"value",SWITCH(TRUE(), 'Table'[year] = 2023, BLANK(), 'Table'[year] <> 2023, 'Table'[value]))
)``````

You can get the table like this.

Create a matrix.

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

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

Top Solution Authors
Top Kudoed Authors