cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
raymondvis
Regular Visitor

Avoiding blank rows in generate and summarize table

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

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

1 REPLY 1
v-jayw-msft
Community Support
Community Support

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.