topic Re: Missing rows in DAX Commands and Tips

Missing rows

Anne_PBI — Thu, 28 Nov 2024 09:06:28 GMT

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

Re: Missing rows

johnt75 — Thu, 28 Nov 2024 10:10:32 GMT

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

Re: Missing rows

Anonymous — Fri, 29 Nov 2024 09:19:54 GMT

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