Forum Discussion

Nosh10's avatar
Nosh10
Icon for Helper II rankHelper 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), 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)

 

 

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.

     

5 Replies

  • 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

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

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

    • Nosh10's avatar
      Nosh10
      Icon for Helper II rankHelper II
      6 years ago

      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's avatar
        v-xuding-msft
        Icon for Community Support rankCommunity Support
        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.