cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
danextian New Contributor
New Contributor

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

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Measure to show current selection

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
		)

 

Capture.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Measure to show current selection

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
		)

 

Capture.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

danextian New Contributor
New Contributor

Re: Measure to show current selection

Hi @v-shex-msft

 

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. 

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
www.linkedin.com/in/danebelarminocpa

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (4,626)