Forum Discussion

danextian's avatar
danextian
Super User
9 years ago
Solved

Measure to show current selection

I've been trying to do this but just can't get it right so I'm here again asking for your help. Thanks in advance.   how do i do this? none or all selected = all categories are selected two or mo...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi danextian,


    >>I can't the "multiple" selection part right.

    Measure not support show multiple values, if your select multiple values, you should merge them to one:

     

    SelectItem = 
IF(COUNTROWS(ALL(User))=COUNTROWS(ALLSELECTED(User)),
	"All or None",//check all or none
	if(HASONEVALUE(User[First Name]),
		VALUES(User[First Name]),//single
		CONCATENATEX(VALUES(User[First Name]),[First Name],","))//mutiple
		)

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi danextian,


>>I can't the "multiple" selection part right.

Measure not support show multiple values, if your select multiple values, you should merge them to one:

 

SelectItem = 
IF(COUNTROWS(ALL(User))=COUNTROWS(ALLSELECTED(User)),
	"All or None",//check all or none
	if(HASONEVALUE(User[First Name]),
		VALUES(User[First Name]),//single
		CONCATENATEX(VALUES(User[First Name]),[First Name],","))//mutiple
		)

 

 

Regards,

Xiaoxin Sheng

  • danextian's avatar
    danextian
    Super User
    9 years ago

    Hi Anonymous

     

    Thanks for your help. I was able to show "multiple". I used countrows(Tabe[User]) since I crossfilter using visuals and not through a User slicer.