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 data in the the below format. I'm trying to get the average of SpareParts by Total, If I select a Location like DEF, it needs to get all the locations in that sector which is AB and also only the locations belongs to the same category which is A here. So it needs to eliminate line I from the result set. And it should do an average of (25% + 55%+ 3% + 50%) which is 33.25%
I am using this formula which is not getting the right result.
Here is the demo file.
Hi Sidhu,
Try this. It will calculate the average correctly depending on the filterd data, as shown in the table you have.
AVERAGE has the bad habit of not calculating correctly when applying filters.
See this forum post for more detail.
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 |
---|---|
46 | |
26 | |
21 | |
12 | |
8 |
User | Count |
---|---|
75 | |
51 | |
45 | |
15 | |
12 |