show items with na data on a group field

[tvanover]

Hi,

I have a report where I link a table with sales orders lines, to a table with delivery lines

because 1 sales order line can have one or more delivery lines, and I am only interested in the total delivered quantity, I have made an aggregate field on the sum of the delivery lines quantity field.

that works well, if there is at least one delivery line.

But I also want to see a record for a sales order line, if there is no delivery line.

If I wasn't grouping the quantity field, I could use the 'show items with no data' option.

But on a grouped field, this option is not available.

So how do I solve this problem?

thx,

Tom

[v-yangliu-msft]

Hi  @tvanover ,

Before grouping, it exists in the empty value row, so you can display the show items with no data option

Once grouped, the null values are summarized and cannot be displayed

If my answer is not what you need, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Best Regards,

Liu Yang

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

[AllisonKennedy · Accepted solution]

I'm not sure what you mean by 'grouped field'. How have you done the aggregation? You still be able to set 'show items with no data' on the sales order line field? And just use a measure for: 

Qty Delivered = SUM(DeliveryTable[Qty])