Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
27 | |
20 | |
15 | |
12 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
18 |