Measure to show current selection

[danextian]

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 more selected = multiple categories

one selected = category name

I can't the "multiple" selection part right. The card always  shows "all categories are selected". I wrote something like

measure = if(not(hasonevalue(column_name)),"all",values(column_name))

[Anonymous · Accepted solution]

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]

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.