Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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))
Proud to be a Super User!
Solved! Go to 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
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
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.
Proud to be a Super User!
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |