COUNTA + UNIQUE + FILTER returning 1 instead of 0, IFERROR not working

[desklamp33]

Hello!

I need to count unique values based on two criteria and this is the formula I've come up with. It successfully gets what I want, EXCEPT it returns a 1 when it should be returning a 0. I tried adding in an IFERROR function so that it doesn't count any #N/A's that the FILTER function returns but that is not working.

=COUNTA(UNIQUE(IFERROR(FILTER(2021_sales[SKU],(2021_sales[Price Bucket]=[@[Price Bucket]])*(2021_sales[Subcategory]=[@Subcategory])),"")))

Thank you!

 

[Fluff]

Hi & welcome to MrExcel.
Swap the Counta for Rows & wrap it in Iferror.

EDIT:
And remove the existing Iferror

 

[desklamp33]

Hi & welcome to MrExcel.
Swap the Counta for Rows & wrap it in Iferror.

EDIT:
And remove the existing Iferror

That worked - thank you so much!

For anyone else viewing this thread, here is the formula that solved my issue:
=IFERROR(ROWS(UNIQUE(FILTER(2021_sales[SKU],(2021_sales[Price Bucket]=[@[Price Bucket]])*(2021_sales[Subcategory]=[@Subcategory])))),0)

 

[Fluff]

You're welcome & thanks for the feedback.