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.
It's frustrating that it's so complicated to find such a simple answer.
I have a table of unique customers and their orders (can of course be more than one order (with multiple lines), per customer.
I have this filter by a customer, and I simply want to find the average value of the unique orders in this list. Ideally not including zero dollar value. So, in this case, summing up the three orders below and dividing by the distinct count of orders (orders that are not zero value).
Any help is appreciated!
Solved! Go to Solution.
Ok, just found the solution:
I have a dataset that has 2 years of data by accounts. I want to find the Avg. of the Distinct account names for each year. I have distinct count of account names but because account names is not a value I cannot figure out how to find the average?
Hi,
Try this measure
Measure = averagex(values(Calendar[date]),[your measure])
Ensure that you drag Year and Month name from the Calendar Table.
So I used the formula above but this is what is showing. The Avg of the number displayed in the table should be 89.8. I have same filters applied. I only want it to show the average of what is displayed in the table. Would that be a different measure?
Ok, just found the solution:
Hi @Anonymous,
Thank you for sharing the DAX expression.😊 I think they may help others who has a similar requirement.
Regards,
Xiaoxin Sheng
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |