Harvest multiple values from a slicer

[Anonymous]

Hey folks,

I am trying to create a measure that harvests multiple values from a slicer and display on a page title. The formular currently in use is only capable of harvesting 1 value and return "More than a month selected". The formular is as below.

SELECTEDVALUE('MTD Forecast'[DateforPreviousYears].[Month],"More than a month selected")

An ideal solution will show as selected, which will vary from "January, March" to "Quarter 1"  as desired (the variable 'DateforPreviousYears" is a Date hierarchy).

Any suggestions?

[daXtreme]

VALUES will return a table with all the values selected in a slicer but such a table can't be used directly in a report. A measure must always return a single value with no exceptions. So, to visualize all the values selected in a slicer you have to also use the CONCATENATEX function over VALUES to turn the individual rows of the virtual table into a string that can then be displayed.

[Anonymous]

It works like perfectly @daXtreme . Thanks for that.

[v-easonf-msft · Accepted solution]

Hi， @Anonymous 

To harvest multiple values from a slicer, you can try  in VALUES('Table'[column]) to replace SELECTEDVALUE('Table'[column]).

If I misunderstood, please share a sample pbix or relevant screenshots to further clarify your question.

Best Regards,
Community Support Team _ Eason
 

[Anonymous]

Thanks @v-easonf-msft. I think you got it quite right...only a slight difference. The challenge isnt to harvest value..but values. Using the Value DAX command failed to harvest values. When I selected more than 1 variable, the solution crashed.

[v-easonf-msft]

Hi, @Anonymous 

Please show the full formula you are currently using or related screenshots.

This will better help me understand the question.

Best Regards,
Community Support Team _ Eason

[Anonymous]

Apparently @v-easonf-msft , I need to use the CONCATENATEX function in front of the values function to harvest all the values as advised above.

Thanks for assistance. Truly appreciate it.

[lbendlin]

Instead of SELECTEDVALUE() use FILTERS()