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.
Hello,
I'm not sure if there is a way to do this in Power BI, but I'm creating a table that does the following.
For team EC Saas 2 (column C), how many scrum masters are there (column E), how many product owners (column F) are there, etc
For team Dev (column (C), how many scrum masters are there (column E), how many product owners (column F) are there, etc
For team Oc Dev (column C), how many scrum masters are there (column E), how many product owners (column F) are there, etc
etc......
*The number of scrum masters, products owners, etc are driven by FTEs (column D)
Solved! Go to Solution.
Hi @Nosh10 ,
I create a column to sum FTEs based on each Platform.
Total FTEs per Platform =
CALCULATE (
SUM ( 'Table'[Sum FTEs] ),
ALLEXCEPT ( 'Table', 'Table'[Platform] )
)
For your latest post, I don't think it is the same requirement with the original one. Please try the formula to check if it is what you want. If it isn't, please share the expected results. We will understand clearly.
@Nosh10 , looking at the data that seems like sum and grouping should do it. Can you share sample data and sample output.
Sorry for the mix up.
I'm looking to create an ETF column that does the following:
How many ETFs are in surface
How many ETFs are in construction
How many EFTs are in landscaping
Hi @Nosh10 ,
I create a column to sum FTEs based on each Platform.
Total FTEs per Platform =
CALCULATE (
SUM ( 'Table'[Sum FTEs] ),
ALLEXCEPT ( 'Table', 'Table'[Platform] )
)
For your latest post, I don't think it is the same requirement with the original one. Please try the formula to check if it is what you want. If it isn't, please share the expected results. We will understand clearly.
Hi @Nosh10 ,
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.
Hi @Nosh10 ,
Could you please clarify the specific logic and the different logic between these teams?
Because for now, I don't know what's the differences among them and no calculation logic here.
Thanks
Aiolos Zhao
Proud to be a Super User!
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |