Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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]
)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
33 | |
16 | |
13 | |
10 | |
8 |
User | Count |
---|---|
58 | |
19 | |
12 | |
11 | |
10 |