cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BratKat
Microsoft
Microsoft

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 

 

 

 

1 ACCEPTED SOLUTION
some_bih
Memorable Member
Memorable Member

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

Sarajevo, Bosnia and Herzegovina

View solution in original post

3 REPLIES 3
some_bih
Memorable Member
Memorable Member

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

Sarajevo, Bosnia and Herzegovina
some_bih
Memorable Member
Memorable Member

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

Sarajevo, Bosnia and Herzegovina

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 
 
 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors