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 guys,
I've been trying to solve this issue for some hours but I'm getting nowhere.
Basically, I have two tables, one for ORDER and one for PROJECT. I'm trying to count how many orders on average there are per project. However, I need to filter out projects where the orders are less than 20.
So I've created a measure that only calculates the count of projects where the orders are more than 20:
However, I can't seem to create the measure that counts number of orders that exist WITHIN those projects. I feel like the logic is quite circular because I'm trying to filter a table based on conditons on itself. This is what I've tried, but I'm guessing I'm using the wrong logic.
Solved! Go to Solution.
You could get the average number of orders with
Avg orders > 20 =
AVERAGEX (
FILTER ( VALUES ( 'Project'[Project number] ), [count order id] > 20 ),
[count order id]
)
Thank you! It worked perfectly.
You could get the average number of orders with
Avg orders > 20 =
AVERAGEX (
FILTER ( VALUES ( 'Project'[Project number] ), [count order id] > 20 ),
[count order id]
)
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |