I want to give an All option in a filter for one of my dimensions. I have tried using Get Selected count but it didnt work.
All value would mean here that all values of the dimensions are selected. eg. if product dimension has values A,B,C, All would mean all 3 products are selected and the data will be filtered accordingly.
The expression I used was as follows:
=if(GetSelectedCount(Product)<=1, Product,'All')
I am aware that when no value is selected in the filter, it means that all values are selected and there is no filtering applied. But I need All to be visible as one of the options inside the filter. Is there any way?
