Getting rid of the blank fields of a calculated table

[Applicable88]

Hello,

I'm using a function to group and filter a raw table, but the fields who are filtered out are actually still there. I can see them in the filter pane of PowerBi where I can deselect "empty" fields. But it would be more beneficial to get rid of them already in the function:

Summarized =

CALCULATETABLE (

ADDCOLUMNS (

SUMMARIZE ( Table, Table[Date, Table[Material],Table[TotalAmount] ),

"SummeRest", CALCULATE ( SUM ( Table[Reserve] ) )

),

NOT ( ISBLANK ( Table[Material] ) )

)

the not isblank function apparently has no effect on it.  I still see all the empty fields, which should be filtered out.

Any help is much appreciated.

Thank you very much in advance.

Best. 

[V-lianl-msft]

I have also encountered such problems. I will check the value of the field in the query editor and replace the null value with null.

[FrankAT]

Hi @Applicable88 ,

I think you can use the following measure for the calculated table:

Summarized =
	FILTER (
		ADDCOLUMNS (
			SUMMARIZE (
				Table, 
				Table[Date], 
				Table[Material], 
				Table[TotalAmount]),
			"SummeRest", CALCULATE ( SUM ( Table[Reserve] ) )
		),
		Table[Material] <> BLANK()
	)

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[AllisonKennedy]

The blanks might be coming from the relationship between the tables, https://excelwithallison.blogspot.com/2020/07/what-does-this-blank-mean.html 

Which field in the filter pane has the 'empty' values that you're filtering out? 

Why do you need to create a calculated table for this? It's helpful to understand the final requirement as there may be another way to solve the issue.