Show all the stores where response rate is average of it

[singhpinky123]

I have Stores and corresponding Response Rate,i want to show all the Stores where Response Rate is greater than the average of Response Rate
i.e. average of Response rate=0.43 , then Store 2 and Store 3 should be display on  the map.
I tried 

Measure = COUNTROWS(FILTER('Table','Table '[Response Rate]>AVERAGE('Table '[Response Rate])))
which give the count but i need to show the store.
How to implement that?

Store	Response Rate
1	0.1
2	0.5
3	0.7

[Icey · Accepted solution]

Hi @singhpinky123 ,

Try this:

Measure 2 = 
VAR Avg_ =
    CALCULATE (
        DIVIDE ( SUM ( 'Table'[Response Rate] ), DISTINCTCOUNT ( 'Table'[Store] ) ),
        ALLSELECTED ( 'Table' )
    )
RETURN
    IF ( SUM ( 'Table'[Response Rate] ) > Avg_, 1, 0 )

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it faster.

[camargos88]

@singhpinky123 ,

You want to count the number os stores above the average ?

[camargos88]

@singhpinky123 ,

You can use this measure and filter the visual:

Measure = IF(SUM('Table'[Response Rate]) > CALCULATE(AVERAGE('Table'[Response Rate]), ALL('Table'[Store])), 1, 0)

[singhpinky123]

@camargos88 This solution works but i want the average as a contant.i.e. if i have 100 of stores then it will do average of 100 of stores,then it will show the stores which is greater than average of the Response Rate.