Find average of distinctcount measure

[Anonymous]

Hi,

I need help to find out the average of the month based on a measure

which is the following:

Daily Shipped Units =
CALCULATE(DISTINCTCOUNT(tblDivisionData_Hist[SerialNumber]))

I want to shows the average of these daily values by month instead. How can I do that? 

Thanks in advance.

[kohlivinayak · Accepted solution]

Hi @Anonymous

I don't know the full requirement, what you have asked can be achieved by creating a new table under the modeling tab using the below formula

New_Table_Name = SUMMARIZE(tblDivisionData_Hist,tblDivisionData_Hist[Date],"Distinct Count",DISTINCTCOUNT(tblDivisionData_Hist[SerialNumber]))

And then using this new created table use the distinct count column and average the column now.

Thanks

Vinayak