You can create a parameter to achieve this:
2. Create a calculated field for Manager Measure (named "Population by Business (manager) " :
[Population by Business]
3. Drag "Population by Business (manager)" to Measure Values.
4. Right click on Parameter and "Show Parameter control"
Please find attached sample workbook.
Filter one column.twbx 26.7 KB
Thank you so much!! So simple, and worked perfectly!