Is it possible to filter my visuals with a measure?

[ERing]

I have a simple report like below where I'm showing the Sales Conversion rate in three visuals (a card, a chart, and a chart with state dimension).

I have a measure called APP_Recording_>15_Minutes that counts the rows in my table where two condtions are met.

APP_Recording_>_15_Minutes = CALCULATE(
    COUNTROWS(FILTER('Fact','Fact'[Has_APP_Recording]="Y")),
    'Fact'[APP_Recording_Minutes]>=15
)

My end users have requested that they be able to filter the three visuals using the measure [APP_Recording_>15_Minutes] so that they can see the Sales Conversion % filtered for any Technicians that are below a certain count for [APP_Recording_>15_Minutes].

I've been researching how to solve this, but I have not come up with a solution thus far.

SAMPLE DATA 

[v-saisrao-msft]

Hi @ERing,
I wanted to check if you had the opportunity to review the information provided by @Ashish_Excel @danextian . Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[danextian]

Hi @ERing 

Try this:

Sale_Conversion_Rate Filtered = 
CALCULATE (
    [Sale_Conversion_Rate],
    FILTER (
        VALUES ( 'Fact'[Technician_Name] ),
        [APP_Recording_>_15_Minutes] < 2120
    )
)

Also change the referenced measure to this:

APP_Recording_>_15_Minutes = 
COUNTROWS (
    FILTER (
        'Fact',
        'Fact'[Has_APP_Recording] = "Y"
            && 'Fact'[APP_Recording_Minutes] >= 15
    )
)

[ERing]

@danextian Thanks for your solution.

Would it be possible to make the Filter value for [APP_Recording_>_Minutes] dynamic using a parameter or some other technique so that the end user can dynamically select the filter value rather than it being a hard input value (eg 2120) in the measure?

Sale_Conversion_Rate Filtered = 
CALCULATE (
    [Sale_Conversion_Rate],
    FILTER (
        VALUES ( 'Fact'[Technician_Name] ),
        [APP_Recording_>_15_Minutes] < 2120
    )
)

[Ashish_Excel · Accepted solution]

Hi,

Download the PBI file from here.

Hope this helps.