Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Need help with a DAX function for Average on unique values

Hi,   I have a table named Active_Users. It contains values for the count of users per location who have multiple devices in their name. Something like below -    Location---No. of devices---Uniq...
Need Help
  • sktneer's avatar
    sktneer
    7 years ago

    Assuming you have a table called Locations with the sample data you showed, you can create a measure like this...

     

    =DIVIDE(
	SUMX(
		Locations,
		Locations[No. of devices]*Locations[Unique users]
	),
	SUM(
		Locations[Unique users]
	)
)
jdbuchanan71's avatar
jdbuchanan71
Super User
7 years ago

Hello Anonymous 

I think this will get you what you are looking for, you just need to change the name of the table in the measure.

Measure = 
VAR Users = SUM ( 'Table'[Unique users] )
VAR UserDevices = SUMX ( 'Table', 'Table'[No. of devices] * 'Table'[Unique users] ) 
RETURN AVERAGEX ( VALUES ( 'Table'[Location] ), DIVIDE ( UserDevices,  Users ) )