Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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.
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.
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
104 | |
94 | |
76 | |
62 | |
59 |