Forum Discussion
SELECTEDVALUE as variable in DAX table
Hello, I want use value from slicer as varialbe in created table using by DAX
There is slicer with 1 selected value and textfield:
MEASURE: TypeSelected = SELECTEDVALUE('SloučenáData'[Typ], "NB")
Created table:
If I use VAR ZvolenaHodnota = SELECTEDVALUE('SloučenáData'[Typ], "NB"), then still "ZvolenaHodnota" dont react to selected value in slicer.
Thank you for help
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.
2 Replies
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.