Avoiding blank rows in generate and summarize table

[raymondvis]

Hello,

First of all I'm new to this community so hello to all of you! 🙂 I need your help in avoiding blank rows in a function I used to create a table using generate and summarize. 

This is the table I use to get the data from. I need an overview for every week per year how many "Aantal trays" belong in that week and are being produced. This is defined as "Proddatum" means the production starts, and "Leverdatum" means the production ends and the product is shipped. If a row matches the 2 criteria it should be included in the sum of "Aantal trays" for that week:
1. Proddatum <= Weeknumber
2. Leverdatum > Weeknumber

This is the code I use to summarize the information per week:

And this is the resulting table from that code below. As you see some rows in the column "Aantal trays" are empty. I want to find a way to remove these rows from this table. Currently for every unique Artikelnr+Traytype+Variant column item a row is added per week. But in order to keep this table as small as possible, the blank rows should not be created/added. How do I do this?

Hopefully somebody knows a way how. Thank you in advance!

Kind regards

Raymond

[v-jayw-msft · Accepted solution]

Hi @raymondvis ,

Check if rolluogroup() function can help.

https://docs.microsoft.com/en-us/dax/summarize-function-dax#with-rollupgroup 

Or you could just use filter() function to filter the summarized table.

new table = filter(summarized table, column<>blank())

Best Regards,

Jay