Hi Team, I am struggling to get this working when I have blank values in my report and want to filter it to just show those rows (see attached): • I am checking this option when I have null rows -> no data • I have made a change to the metric itself to add (IFNULL (...), 0) clause, so that the null values appear as 0 directly in the metric -> still no data Am I missing something?

Hin Raffaella, the “Treat blank values as 0” option in the measure value filter is designed to include rows where the metric is null (blank) by treating those nulls as zero for the purpose of filtering. When you check this option and set a filter (e.g., “Less than 1"), it should display rows where the metric is either 0 or null. However, if you have already wrapped your metric in an

IFNULL(..., 0)

clause, the metric itself will always return 0 instead of null. In this case, the “Treat blank values as 0” option becomes redundant, because there are no longer any nulls—only zeros. The filter will only show rows where the metric is exactly 0 (or less than 1, depending on your filter), but if your data model or visualization does not generate rows for missing data (i.e., if there is no row at all for a given attribute value), those rows will not appear, regardless of the filter or the IFNULL logic. If you want to display rows for all attribute values (including those with no data), ensure your data model or visualization is set up to show all possible attribute values, possibly by enabling “show missing values” if available. The “Treat blank values as 0” option and IFNULL only affect how nulls are handled in existing rows, not whether missing rows are generated or displayed. If you still do not see the expected rows, it is likely due to the absence of those rows in your data or result set, not the filter or metric logic.

Hello Rafaella, we are just following up on this to check if you have any further questions.