SELECTEDVALUE as variable in DAX table

Hi Hammyssdfs 

If you are creating a calculated table rather than a measure that aggregates a measure it doesnt work like that.

Calculated tables on recalculate when the underlying tables are refreshed:

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-tables

Hi Hammyssdfs ,

As SamWiseOwl  mentioned, The values ​​in the slicer are dynamic, but the values ​​in the calculation table will not change once they are created, no matter what value you select in the slicer , and are still static even if the data is refreshed. you can refer to the following link.

powerbi - Based on slicer selection create dynamic calculated table in Power BI - Stack Overflow.

Solved: Creating calculated table based on slicer selected... - Microsoft Fabric Community

If you want dynamic changes you could consider creating a virtual table in your measure.

Power BI Virtual Table | 5 Tips & Tricks For Debugging – Master Data Skills + AI

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.