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.

     

amitchandak's avatar
amitchandak
Super 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
    Helper 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
      Community 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.

       

      • v-xuding-msft's avatar
        v-xuding-msft
        Community Support
        6 years ago

        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.