Missing rows

[Anne_PBI]

Hi all,

I have a calculated value (calculated in power query, set as decimale value) and it shows the current values per row. Each row is unique.

However, when I sum that same value with the sum option (see printscreens below), it remains blank for some rows. Can anyone help me out? In the end I want to use the summarized value only but it does not show the correct amount and I think it is because of this.

The table with both values:

Settings of the first column set to "do not summarize":

Settings of the second column set to sum:

Added later:

When I remove the measure column, the rows with no value in the summed column disappear even though they are unique values. I think this is causing the issue. However, how to solve it? Filters for both tables are the same and alle columns (except for "SUM of calculated value" are set to do not summarize...

Many thanks,

Anne

[v-yiruan-msft · Accepted solution]

Hi @Anne_PBI ,

Please follow the steps below to do and check if it can display the records with blank values:

1. Select the table visual

2. Navigate to Fields options, select the category field(like the field [index])

3. Right click and choose the option "Show items with no data"

Show items with no data in Power BI - Power BI | Microsoft Learn

Best Regards

[johnt75]

Can you share a PBIX with any confidential info taken out ? You could upload to OneDrive or Google Drive or similar.