topic Re: Harvest multiple values from a slicer in DAX Commands and Tips

Harvest multiple values from a slicer

Anonymous — Thu, 31 Mar 2022 18:25:24 GMT

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?

Re: Harvest multiple values from a slicer

lbendlin — Sat, 02 Apr 2022 23:35:33 GMT

Instead of SELECTEDVALUE() use FILTERS()

Re: Harvest multiple values from a slicer

v-easonf-msft — Tue, 05 Apr 2022 10:54:41 GMT

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

Re: Harvest multiple values from a slicer

Anonymous — Tue, 05 Apr 2022 19:55:05 GMT

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.

Re: Harvest multiple values from a slicer

v-easonf-msft — Wed, 06 Apr 2022 06:17:45 GMT

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

Re: Harvest multiple values from a slicer

daXtreme — Wed, 06 Apr 2022 12:37:39 GMT

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.

Re: Harvest multiple values from a slicer

Anonymous — Wed, 06 Apr 2022 17:33:19 GMT

It works like perfectly daXtreme . Thanks for that.

Re: Harvest multiple values from a slicer

Anonymous — Wed, 06 Apr 2022 17:35:55 GMT

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.