Help please! "No Selection" text from Chiclet Slicer
I cant figure out how to display in a text box with title = "No Selection" if I dont select any filters from the chiclet slicer:
The formula I used is:
VAR _Count = COUNTROWS(VALUES(MICA_Product_Code_Master[Description]))
VAR _Concat = CONCATENATEX(VALUES(MICA_Product_Code_Master[Description]),[Description],", ")
RETURN IF(_Count>3,"Multiple Plan Selection Scorecard",if(_count<3, _Concat & " Scorecard", "No Plan Selected"))
The problem is I don't select any values from MICA_Product_Code_Master[Description], the VAR _Count = 50. As such, it displays "Multiple Plans". I want it to become zero ( VAR _Count = 0) so it will appear as "No Selection" and include it in the formula.