Filter Summarize table with blank values

DAX DAX Calculations
1

Could someone help me understand how to remove the rows with blank values?

image
image581Ă—858 32.7 KB

image
image819Ă—506 11 KB

2

Good evening @Schreg,

Answer: filter the calculated table for only the non-blank “CalcReturn”-values

Filter(_specialProduct, CalcReturn <> blank())

Note 1: Filter recognizes “CalcReturn”, whereas CalculateTable does not, and the latter also gives a error when using “calculate ([sum_GrossPTD], Mapping[ID] = 24914)” instead.

Note 2: You might opt to use a measure instead of a calculated table using this filtering, to avoid calculated tables, to speed up the file

Kind regards, Jan vd Wind

1 Like
3

thank you @deltaselect , this is used as a measure, showing as table here only for clarity. I appreciate the lineage insight! Good to know the advantages of the Filter function.