Dynamic Filter / Sum If

[Nosh10]

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)

[amitchandak]

@Nosh10 , looking at the data that seems like sum and grouping should do it. Can you share sample data and sample output.

[Nosh10]

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

[v-xuding-msft · Accepted 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.

[v-xuding-msft]

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.

[AiolosZhao]

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