Calculated Measure as page or report filter

[afk]

Hi,

I have a dataset that shows visits and registrations for a number of URLs. I've created a measure to calculate the registrations to visits rate (i.e. percentage of those who visit and then register - reg/visits).

Example

Web page	Visits	Registrations	Reg to visits rate
URL1	5000	450	9%
URL2	4000	700	18%
URL3	6000	590	10%

I would like to filter my report so that I exclude any registrations to visit rate of 60% or more. However, I've noticed that it is not possible to apply a measure as a page or report filter.

Is there a workaround for this?

Thanks!

afk

[Greg_Deckler]

So, you might try the disconnected table trick but not sure you'd be able to get it to work the way you want. However, that is the typical work-a-round when you can't use a measure in the particular way that you want. 

In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...