topic Re: Divide by distinct count and get average in DAX Commands and Tips

Divide by distinct count and get average

BratKat — Fri, 02 Jun 2023 19:36:10 GMT

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 — Sun, 04 Jun 2023 20:17:58 GMT

Hi BratKat please provide some sample data with expected output.

BratKat — Mon, 05 Jun 2023 16:06:46 GMT

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

some_bih — Mon, 05 Jun 2023 17:59:35 GMT

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