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
Solved! Go to Solution.
Hi @BratKat I am sorry, this is not enought to get insight what is your model about. If possible, upload pbi file.
Hi @BratKat I am sorry, this is not enought to get insight what is your model about. If possible, upload pbi file.
Hi @BratKat please provide some sample data with expected output.
This is the calculation am using for this
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!