Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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
@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.
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |