Averages Calc

[carlol]

Hi 

I want to get Average number of Procedures by Attending Doctor 

Sum of Procedures / Count of Attending doctors 

I am having issue with Suming up the count of Doctors , it is just divinding the Sum of Procedures by 1

Can somebody point me in the right direction , maybe a better approach or dax function to use ? 

TotalProceduresInclNational =

VAR total =

    CALCULATE([TotalExclAttendingDoctor],ALL(Hospital[Hospital]))

RETURN

    SWITCH(SELECTEDVALUE('Hospital'[Hospital]),"National",total,[TotalProcedures])

Total no. of AttendingDoctors =

VAR NumOfAttendingDoctors = CALCULATE(DISTINCTCOUNT(AttendingDoctor[AttendingDoctor]))

                                       Also tried --CALCULATE(COUNTROWS(AttendingDoctor),

AllEXCEPT(AttendingDoctor,AttendingDoctor[AttendingDoctor]))

VAR Results = NumOfAttendingDoctors

Return

Results

AverageProceduresCarriedOut =

VAR TotalProcedures = [TotalProceduresInclNational]

VAR AttentingDoctorCount = [Total no. of AttendingDoctors]

VAR Results =

DIVIDE(TotalProcedures,AttentingDoctorCount)

Return

Results

[Ritaf1983]

Hi @carlol 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523