Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
similart to this thread, however i want to know if there is a way to have these customers grouped
https://community.powerbi.com/t5/Desktop/Not-Selected-Values/m-p/572530#M270416
Table1 has Column CUST and another Table2 Column CUST in groups.
Slicer is PIN to CUST Column in Table 1, if User selects multiple value such as CUST1, CUST5, CUST 8,.....etc. Is there a way to list rest of the not selected values based on the grouping of these customers?
here is the link to the file
https://www.dropbox.com/s/1fg0pvc3ptkd7tv/Not%20Selected%20Values.pbix?dl=0
Thanks
Solved! Go to Solution.
Hi @powerBIpeon
You may try below measure:
Measure = CONCATENATEX ( FILTER ( Table2, Table2[Group] = MAX ( Table2[Group] ) && NOT ( Table2[Cust] ) IN VALUES ( Table1[Cust] ) ), Table2[Cust], "," )
Regards,
Cherie
Maybe, seems like you could borrow the concept from my Inverse Aggregator which was created to do something similar:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Aggregator/m-p/342266
@Greg_Deckler - the formula does work, but its repeating the the non-selected customer multiple times in the group. I changed the SUM to CONCATENATEX
InverseSum = IF( ISFILTERED('InverseAggregator'[Category]), CALCULATE( CONCATENATEX('InverseAggregator'[Value]), EXCEPT( ALL('InverseAggregator'[Category]), VALUES('InverseAggregator'[Category]) ) ), CONCATENATEX('InverseAggregator'[Value]) )
This is what the output is when CUST1 is not selected.
Group1 - CUST1 CUST1 CUST1 CUST1 CUST1
Hi @powerBIpeon
You may try below measure:
Measure = CONCATENATEX ( FILTER ( Table2, Table2[Group] = MAX ( Table2[Group] ) && NOT ( Table2[Cust] ) IN VALUES ( Table1[Cust] ) ), Table2[Cust], "," )
Regards,
Cherie
Thank you both for the help!
OK, I'll have to take a look at it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |