How to place a calculated measure on a slicer/filter

[sherrybay]

I have a very simple set of calculations: how many times a consumer has received certain services

# of times a consumer has received an assessment

# of times a consumer has attended a tutoring appointment, etc.

# of times a consumer has received a reminder phone call

I have other filters that are typical slicers like site or program that I can easily put on the usual Power BI filters. 

Our analysts want to set criteria such as all consumers having more than 1 assessment, 1 reminder call at Site A. 

Right now, I can't put the "# of time" calculations on the Power BI slicers. In Power BI desktop I can set them up as Visual slicers on the righthand side, but it doesn't work with the other slicers in the web version. Any ideas on why this doesn't work in the web version? 

Thanks for any help. 

Best,

Sherry

Sherry

[stretcharm]

You cannot use a Measure for slicer.

If your calc works as a computed column then this can be a slicer.

You can also write a measure that can be added to the filters e.g. MeetCriteria Yes or No and visual/page filter to the desired setting. Bookmarks can let you toggle between the states and a couple of image can trigger the bookmarks.

The guys at SQLBI have aslo provided a soltion to this in relation to PowerPivot but it's the same for PowerBI

http://www.daxpatterns.com/parameter-table/

Hope this helps

Phil