Forum Discussion
Adidas
Helper I
Helper IHow to retrieve a slicer selection into another table
Hi all, I'm trying to achieve this with Dax but still no success, My powerBI report has a table with a list of employees, and two additional columns of products allocated for each employee. In ea...
Adidas , Not very clear to me.
Try a measure like
measure =
var _prd = allselected(product[product])
return
calculate(countrows(employee) , filter(employee, employee[product] in _prd))or try to use treatas
amitchandak
Super User
Super UserAdidas , Not very clear to me.
Try a measure like
measure =
var _prd = allselected(product[product])
return
calculate(countrows(employee) , filter(employee, employee[product] in _prd))
or try to use treatas
AdidasHelper I
Helper IThanks, amitchandak
the measure is working great!
however, is there a way to avoid the typical behavior of a power bi slicer
that "no selection" means "all selections"?
Of course, there is. Just use the ISFILTERED function.