Forum Discussion
CALCULATETABLE() + SELECTEDVALUE as Filter ?
Hi, I such a way for create a table based on value which is based on another table onclick,
Thats doesnt work 😞
Testtable =
var selval = SELECTEDVALUE(MyTable[Quantity])
return CALCULATETABLE(
MyTable,
FILTER(
ALL(MyTable),
MyTable[Quantity] = selval
))
1 Reply
- Stachu
Community Champion
this is not achievable in the import mode, calculated columns and tables are refreshed with the model and do not change with the slicer selections (you could have the same slicer in multiple pages with different values, so the model would not be in a consistent state)
As far as I know it's only possible with DirectQuery and dynamic M parameters:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
