Forum Discussion
Concatenate rows values based on filter context
Hi, I am trying to capture the values selected in a slicer so I can display a notification on screen such as "You have selected the following: A, B, C). For displaying if a single value is se...
Solved it. Just in case anyone wants to see the solution:
TerritoriesSelected = "You have selected the following territories: " & CONCATENATEX(VALUES(Rev[Territory]),Rev[Territory],", ")
Best,
Scott
Solved it. Just in case anyone wants to see the solution:
TerritoriesSelected = "You have selected the following territories: " & CONCATENATEX(VALUES(Rev[Territory]),Rev[Territory],", ")
Best,
Scott