Can I use calculatetable function with the filter value coming from slicer's selected value ?

[Anonymous]

Can I use calculatetable function and apply slicer's selected value(text) as filter for the function  ?

minitable = calculatetable(facttable, productid = selectedvalue(dimproduct[id]))

thanks 

[v-juanli-msft · Accepted solution]

Hi @Anonymous 

calculatetable function will generate a table, if you use it in "New Table", a table is a fixed one and doesn't change with slicer.

If you use calculatetable function in a measure as a virtual table, it can work with dynamic values.

Best Regards
Maggie

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.