cancel
Showing results for
Did you mean:
Helper V

## Average for data

I have columns: Date | Card Reads | City

I need to calculate the average card reads by city and compare it to a specific address. So basically when I slect an address within that city, I want the SUM(Card Reads) to populate against that city's average.

1 ACCEPTED SOLUTION
Community Champion

Hey @bhmiller89 ,

create a measure for the average card reads:

``````Average Card Reads =
CALCULATE(
AVERAGE( myTable[Card Reads] ),
ALLEXCEPT(
myTable,
myTable[City]
)
)``````

And then do your calculation with the sum. As far as I understood you just want to divide it:

``````Card Reads to Average =
DIVIDE(
SUM( myTable[Card Reads] ),
)``````

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

2 REPLIES 2
Community Champion

Hey @bhmiller89 ,

create a measure for the average card reads:

``````Average Card Reads =
CALCULATE(
AVERAGE( myTable[Card Reads] ),
ALLEXCEPT(
myTable,
myTable[City]
)
)``````

And then do your calculation with the sum. As far as I understood you just want to divide it:

``````Card Reads to Average =
DIVIDE(
SUM( myTable[Card Reads] ),
)``````

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Community Champion

Hey @bhmiller89 ,

did it work with the measures?

I'm curious if you could solve this issue 🙂

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Announcements

#### Manage your user group events

Check out the News & Announcements to learn more.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

#### Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Top Kudoed Authors