Calculate the average of a distinct count measure

[amulder]

Hi,

Can someone please help me with the syntax to find the average of a measure using DISTINCTCOUNT. Here is the syntax of my measure:

Number of Units = DISTINCTCOUNT( LoggedInData[Unit_ID] )

I was hoping I could just do something like this: Avg Number of Units = AVERAGE(DISTINCTCOUNT(LoggedInData[Unit_ID])) but that doesn't work as I am not able to reference my measure.

My Number of Units measure counts the number of times a unique Unit_ID appears in my LoggedInData table.

Thanks!

 

[VBA Geek]

https://community.powerbi.com/t5/De...f-a-distinct-count-measure/m-p/542610#M254880