Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Is there a way to list non selected values from the slicer?
I have a Customer Table with Column CUST
Slicer is PIN to CUST Column, if User selects multiple value such as CUST1, CUST5, CUST 8,.....etc. Is there a way to list rest of the not selected values in the grid. I mean like opposite to ALLSelected?
Thanks in Advance.
Solved! Go to Solution.
Hi @Anonymous,
Please download the demo in the attachment.
Measure = CONCATENATEX ( FILTER ( ALL ( 'Table1'[Cust] ), NOT [Cust] IN VALUES ( Table1[Cust] ) ), [Cust], "," )
Best Regards,
Dale
Hi @Anonymous,
Please download the demo in the attachment.
Measure = CONCATENATEX ( FILTER ( ALL ( 'Table1'[Cust] ), NOT [Cust] IN VALUES ( Table1[Cust] ) ), [Cust], "," )
Best Regards,
Dale
Amazing! Thank you!
What if the the customers where grouped? How would the relationship or function look like?
Group 1 = cust1 to cust5
Group 2 = cust1 to cust3
Group 3 = cust3, cust4
Hi @powerBIpeon,
I would suggest you create a new thread in this forum with a little sample. The solution depends on your data model.
Best Regards,
Dale
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |