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.
I have a measure known as abc rate. I have a filter that allows a user to select a particular month (numerical options: 1-12). When someone selects a month (via a filter), they see the abc rate for that particular month.
My problem is if someone selects multiple months (ex: 1, 2, 3 in the filter), the resulting value of abc rate is not the average. Quite frankly, I'm not too sure what it is, so I'd like to create a measure that represents the average connected rate.
The average connected rate should be the sum of the connected rates for {x, y, z} months / total number of months selected, where {x, y, z} are the selected months. I've tried AVERAGEX(DateTable, [abc rate]) but that doesn't give me the right average either. Does anyone know what the correct DAX formula is?
What is the formula you have written for abc rate?
It is total number of apples / green apples. Total number of apples is also another measure. Abc rate uses data from multiple data tables.
Hi,
That is still not clear enough. Share the link from where i can download your PBI file and show the expected result there. Share only minimal information/tables in the file so as to avoid confusion.
I'm afraid the data I'm working with is protected. Based on the information above, is there a way to compute the average of a measure (of x selected entries in a filter)? The calculation of the measure itself ideally is isolated from finding the average of it.
Hi @bubblepop ,
Sorry that I'm not clear about your requirement. Could you please create a simple sample data with fake data and calculation logic? So that we can understand your requirement. Thank you.
In addition, you can refer the method in the following threads by using DIVIDE function and check whether it can resolve your problem.
Calculate an average from a Sum by Month
Best Regards
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |