cancel
Showing results 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 ?

Proud to be a Super User!

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

Proud to be a Super User!

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.

Announcements