Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

exclude blank rows in new table

I created an new table where i summarized the sale by product group. Some product groups have no value.. what dax formula should I use in order to exclude them thank you
Need Help
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

Could you post your table structures with some sample data, and the formula you're using to create the new summarized table?

 

Based on my test, if I use SUMMARIZECOLUMNS Function (DAX) to create the summarized table, the product groups that have no value will be excluded by default. :smileyhappy:

 

Summarize Table = SUMMARIZECOLUMNS ( Table1[Product group], "Total Sales", SUM ( Table1[sales] ) )

 

Regards