Forum Discussion

Nosh10's avatar
Nosh10
Helper II
6 years ago
Solved

Dynamic Filter / Sum If

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), h...
Need Help
  • v-xuding-msft's avatar
    v-xuding-msft
    6 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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