Forum Discussion

BratKat's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Solved

Divide by distinct count and get average

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's avatar
    some_bih
    3 years ago

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

3 Replies

    • BratKat's avatar
      BratKat
      Icon for Microsoft Employee rankMicrosoft Employee
      3 years ago

      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's avatar
    some_bih
    Icon for Community Champion rankCommunity Champion
    3 years ago

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