Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everybody,
here is my problem; I wrote this Dax and it is working flawlessly:
Solved! Go to Solution.
Hi , @psfard85
According to your dax you provide , Here are my understand for your question:
(1)If you use "New Table" to return a table , it cannot use the SELECTEDVALUE() function because the filtering context of the slicer cannot be obtained in the new table.
(2)If you define the table in a measure, if you filter the slicer, the current filter context is automatically modified back, and we don't need to modify the current filter context as shown.
For your needs, you can provide some trusted input and output sample data so that we can better help you.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @psfard85
According to your dax you provide , Here are my understand for your question:
(1)If you use "New Table" to return a table , it cannot use the SELECTEDVALUE() function because the filtering context of the slicer cannot be obtained in the new table.
(2)If you define the table in a measure, if you filter the slicer, the current filter context is automatically modified back, and we don't need to modify the current filter context as shown.
For your needs, you can provide some trusted input and output sample data so that we can better help you.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.