cancel
Showing results for
Did you mean:  Helper V

## DAX Results Above or Below Average

Hi

I require a DAX measure to work out if the number of repairs per Address line are above or below the total average for all addressess and repairs.

I have two tables

2- Repairs by address row by row

Example of tables

The visual table for the results will contain the following columns. I am using a DAX measure to count the number of repairs per address.  I have another DAX measure that works out the average number of repairs for all addressess  Count Repairs / Count Addressess = Average Repairs

 Address Count of Repairs 1 Nonsense Street, London 2 2 Unknown Road, London 5 3 High Road, London 3 4 Dax Lane, London 1 5 Power Road, London 3 6 Excel Street, London 5 7 Variable Lane, London 1 8 Calculate Street, London 5

I would like to add a 3rd columns that does the following. If Count Repairs > Average Repairs then " Above Avg" If Count Repairs < Average Repairs then " Below Avg"

Richard

1 ACCEPTED SOLUTION  Community Champion

Here is the formula Number of repairs by address =
return

here is the formula

Avarage repairs, here is the picture By the way it is better to use DIVIDE for avarage repair
Avarage repairs = DIVIDE([Number of repairs by address], [Count of address], 0)

Regards
Amine Jerbi

5 REPLIES 5  Helper V

Thank you for your quick response. Silly question but how did you calculate the count of address shown in the 3rd column  Resolver II

and create new table in modeling  by using summarize function   Resolver II   Helper V

Thank you for your quick response. Silly question but how did you calculate the count of address shown in the 3rd column  Community Champion

Here is the formula Number of repairs by address =
return

here is the formula

Avarage repairs, here is the picture By the way it is better to use DIVIDE for avarage repair
Avarage repairs = DIVIDE([Number of repairs by address], [Count of address], 0)

Regards
Amine Jerbi    