The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
52 | |
26 | |
14 | |
14 | |
12 |
User | Count |
---|---|
107 | |
38 | |
25 | |
23 | |
19 |