Pass the values of a slicer selection to a list variable

[webportal]

I have a calculated table with an expression like:

Table = 
VAR MyVar = {1;2;3}
...
RETURN
SELECTCOLUMNS(...)

This returns a table with a single column. The rows depend on the list defined manually in "MyVAR".

I'd like to pass the values of a slicer selection to that list.

Is this possible to do in Power BI Desktop? How?

Thanks in advance!

[OwenAuger · Accepted solution]

HI there,

Unfortunately calculated tables (and calculated columns) are computed at report refresh, so they are unable to make use of slicer selections or other filters within a report.

Depending on what you're trying to do, another option may be to build the table as a variable within one or more measures (which can take into account slicer selections) and use that table somehow within those measures.

Something like the feature you're looking for (i.e. creating a table function that responds to filter context) was discussed here recently. While it can't be done in Power BI Desktop right now, it can be done in Analysis Services 2017 or Azure Analysis Services, and with any luck it wil be possible in Power BI Desktop in the future.