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 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))

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

2 Replies

  • 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.