Group/Count/Sum/Divide

[Anonymous]

Hello All,

First Time poster and new user to Power BI.  I have a question regarding an example of data below.  Those three columns are just three in a table of about ten, but those are only the ones I need to reference in this example. 

Week	Trip	Miles
21	1245	54
21	1245	72
21	1789	54
22	1279	45
22	1122	87

What I am trying to do is create a measure that will Group the 'Week," while counting the "Trip" by distinct and will sum up the "Miles" at which time I want to dive the "Miles" by the Trip Count for a Miles per trip calculation.  

Let me know please and thank you in advance for your help.  

[Fowmy · Accepted solution]

@Anonymous 

I created this measure, please try:

Measure = 

SUMX(
    SUMMARIZE( TABLE, TABLE[Week] , "SUM", DIVIDE( SUM(TABLE[Miles]),DISTINCTCOUNT(TABLE[Trip]))),
    [SUM]
)

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn