I am creating a dynamic text box based on filters on product and country.
I want something like 'You are now looking at sales for "product" from "country".'
The filter then decides which country and product is mentioned in the text box.
My problem is, that if all product are shown (hence, there is no filter on "product"), then I don't know the filter syntax.
I tried something like the following
If(Product = null(), 'all products', Product), but the "null()" is incorrect. So my question is, what is the syntax for a non-filtered filter?
There are too many products to mention them all in a combined if-statement.