Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
I have the fields, Surgeon, Date, Start Time, End Time, Facility, OR.....I would like to find a surgeons average start and end times, overall, but then also be able to find it by Day of Week, Facility, OR, if adding these fields to the visual. I have the formula:
Solved! Go to Solution.
Without knowing the data model, data samples, and what is the output expected, it is tough to advice. For me, it sounds like you are doing average by group and your formula is correct in my view:
Anes Start Average =
CALCULATE(
AVERAGE('Case Details'[Anes Start]),
ALLEXCEPT('Case Details',
'Case Details'[Surgeon],'Case Details'[Facility],'Case Details'[OR])
)
Quick check tip: add and delete this table to verify
Assuming you have in the data model, a relation between Calendar Table and Case Details.
1. Click "New Table" in the modeling and add table via DAX
2. Dax formula
New Table = SUMMARIZE( 'Case Details'
, 'Case Details'[Surgeon]
, 'Case Details'[Facility]
, 'Case Details'[OR]
, 'Calendar Table'[Month & Year]
, "Rows Count 1", Count('Case Details'[Anes Start])
, "Avg. Test 1", AVERAGEX('Case Details', 'Case Details'[Anes Start]))
, "Avg. Test 2", AVERAGE('Case Details'[Anes Start])
)
Let us know if you see the results the same way you want?
Hi,
Share some data to work with (in a format the can be pasted in an MS Excel file.) and show the expected result.
Hi @aashton,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Without knowing the data model, data samples, and what is the output expected, it is tough to advice. For me, it sounds like you are doing average by group and your formula is correct in my view:
Anes Start Average =
CALCULATE(
AVERAGE('Case Details'[Anes Start]),
ALLEXCEPT('Case Details',
'Case Details'[Surgeon],'Case Details'[Facility],'Case Details'[OR])
)
Quick check tip: add and delete this table to verify
Assuming you have in the data model, a relation between Calendar Table and Case Details.
1. Click "New Table" in the modeling and add table via DAX
2. Dax formula
New Table = SUMMARIZE( 'Case Details'
, 'Case Details'[Surgeon]
, 'Case Details'[Facility]
, 'Case Details'[OR]
, 'Calendar Table'[Month & Year]
, "Rows Count 1", Count('Case Details'[Anes Start])
, "Avg. Test 1", AVERAGEX('Case Details', 'Case Details'[Anes Start]))
, "Avg. Test 2", AVERAGE('Case Details'[Anes Start])
)
Let us know if you see the results the same way you want?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
76 | |
56 | |
38 | |
34 |
User | Count |
---|---|
99 | |
56 | |
51 | |
44 | |
40 |