Retrieve multiple selected values in grid from slicer

[Tejasvi_munge]

Here is the scenario-
I want to show the multiple selected values from slicer into grid.

SELECTEDVALUE function is working fine for single selected value but not for multi-select values. 

Above fig shows count of slicer for single value. I want to have similar count for mutli-selection. For instance, if I select 1,2 and 3 then grid should show the values as 1,2 and 3.

Here, I am able to able to get the values in string format by using below DAX-

selectedvalues=CONCATENATEX(ALLSELECTED(CATEGORY3),CATEGORY3,",") 

Is there any other solution for this ? Also,further I want to pass those values into other DAX. 

Thank you in advance.

[v-yuta-msft]

@Tejasvi_munge ,

What's your requirement? If you want to concatenate the selectedvalues as a new number value, could you please clarify your logic?

Regards,

Jimmy Tao

[Tejasvi_munge]

I need this-

[v-yuta-msft · Accepted solution]

@Tejasvi_munge ,

In this senario, you don't need to create any measure, just enable the interaction between table visual and slicer visual.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Can you use VALUES() DAX. Please refer the below article.

https://community.powerbi.com/t5/Desktop/display-multiple-elements-with-SELECTEDVALUE/td-p/650754

Best Regards,
Vignesh M

If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂

[Anonymous]

Hi,

Have you tried using FILTERS() DAX Function.

Best Regards,
Vignesh M

If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂

[Tejasvi_munge]

yes, FILTERS() is also working for single selection of slicer and not for multi-selection same as SELECTEDVALUE().