Volume per Count of Customers per period = Average Customer Volume per Month

[Anonymous]

Hi,

I'm trying to establish the CNT per Customer per Month.

For example Sum of Chem_17CNT per COUNT of all Cust SAP NU...  per RunYearM

So In the table below for the first line of 2018M01 I'd like to see that total CNT (2734) divided by the COUNT of Customers.

Hence the average CNT per customer in 2018M01

How can i do that with a measure?
Many thanks!

[Anonymous]

it isn't working unfortunately. 

I tried:

divide(table[chem17cnt],distinctcount(table[customer])) but i think i'm missing a filter for the month. I've PMed you Amit. Many thanks

[amitchandak]

@Anonymous , Try a measure like

divide(count(Table[customer]), distinctcount(Table[customer]))

if did not work

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.