cancel
Showing results for
Search instead for
Did you mean: Frequent Visitor

## Show all the stores where response rate is average of it

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
1 ACCEPTED SOLUTION  Community Support

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.

4 REPLIES 4  Community Support

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.  Super User III

You want to count the number os stores above the average ?  Super User III

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)`` Frequent Visitor

@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.  ## Helpful resources

Announcements #### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group #### The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings. #### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event. Top Solution Authors
Top Kudoed Authors
Users online (17,949)