Divide by distinct count and get average

[BratKat]

Have a new Column calculated from two other existing columns

Total  = CALCULATE(COUNT('Work Items'[Column1]),'Work Items'[Column2] in {"Item1","Item2" })

Dividing by another column using distinctcount

Average = ([Total])/(distinctcount('Work Items'[IncidentID]))

(Number of total divided by number of distinct IncidentsIDs)

Trying to get the Average of the division value but can’t get the average syntax to work with this. 

Thank you 

[some_bih · Accepted solution]

Hi @BratKat I am sorry, this is not enought to get insight what is your model about. If possible, upload pbi file.

[some_bih]

Hi @BratKat please provide some sample data with expected output.

[BratKat]

This is the calculation am using for this 

SevVols = ([Escort Bookings]+[ICM Incidents])/(distinctcount('Work Items'[IncidentID]))

Escort Bookings and ICM Incidents are count of items, for example 

Escort Bookings and ICM Incidents = 20 

IncidentID is distinctcount of number of actual incidents = 35