Hi, I have been struggling to calculate some form of Weighted Average for 7 incident groups (“Our Mosaic Group”) based on property(population) size on a different table.
I’m ideally looking to rank the incidents count based on the “weight” of the property size
So instead of counting the no of incidents per group, I’m looking to weigh it based on the population size : “Properties” on a different table.
Table 1 (Fire data) has incidents and Table 2 (Groups Data )has the property size.
Linked by Mosaic type field
The formula I used is this:
weighted Average = DIVIDE( SUMX('Fires Data cleaned 2', [Count of Incidents] * RELATED('Groups Data'[Properties])), SUMX('Fires Data cleaned 2',[Count of Incidents] ) )
But I wanted to check that it is the right way of looking at it.
Attached is my pbix fileSegmentation annon.pbix (204.9 KB)