Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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]
)
User | Count |
---|---|
57 | |
21 | |
18 | |
16 | |
12 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |