Forum Discussion
Help With Aggregation
Hello! I am working on a dashboard that shows ticket counts per 1000 Employees per region, as well as overall data. I got the 'per region' data to look correct, but the overall data is giving me...
Sum(Distinct Ticket Count)/(AVERAGE(number of employees)/1000)
could be written as
measurename =
DIVIDE (
SUM ( 'table'[Ticket Count] ),
CALCULATE ( AVERAGE ( [number of employees] ) / 1000 ),
removefilter ( 'table'[region] )
)