topic Volume per Count of Customers per period = Average Customer Volume per Month in DAX Commands and Tips

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

Anonymous — Fri, 27 Nov 2020 15:58:08 GMT

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!

amitchandak — Fri, 27 Nov 2020 16:37:35 GMT

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.

Anonymous — Fri, 27 Nov 2020 18:48:33 GMT

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