Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
19 | |
14 | |
10 |
User | Count |
---|---|
57 | |
49 | |
44 | |
18 | |
18 |