How to get the value of the selected row in the table to a var in dax?

[yoav20007]

i wont to creat a table base of the selected row of other table .
this code give me a empty table.
pls help 🙂 

Thanks

Yoav

Table =

var myprice= [TotalPrice]

var mydate=SELECTEDVALUE('Sheet1'[Date])

return

FILTER('Sheet1',

'Sheet1'[Price]<Myprice && 'Sheet1'[Date]=mydate)

[CloudJoh]

Hi, what you want to do is not possible in PowerBI at the moment. 
However, I just found a way to do it, albeit a bit complicated. And you'll need a sharepoint folder for this to work. 
1. Create a Power automate component that takes in your selected value as data
2. Create a Power Automate Cloud flow that : 
   2.1 check if there is an excel file existing for that session, if no, creates one

   2.2 adds a line into the excel file for that session containing the selected value 
   2.3 actualises the data for that source only
3. create your second table using that excel as your source. 
This will require pushing a button everytime you want to add a line but it works very well. 

[Greg_Deckler · Accepted solution]

Tables are not dynamic, they are only calculated at the time of data load.

[yoav20007]

if i changing the var to a number the table work good

in this case i does what i want
I think i need to change the var line to a measure ?

[yoav20007]

The resualt shout be a table. 
how can i filter 1 table and save the resualt as a new table . like an advance  filter in Excel ? 

[yoav20007]

Thank

So, how can i do it dynamic? 
do you have a sulotion to do it?