Forum Discussion

FOXYBARK's avatar
FOXYBARK
Icon for Helper III rankHelper III
4 years ago
Solved

Simple SumIfs in PBI

HI Team.  I appreciate the help in advance.  I would like to replicate a SUMIFS function in PBI. My sample data is shown below. In the example, my answer would be 6. I would like a new column to li...
DAX Calculation
  • AnthonyJoseph's avatar
    AnthonyJoseph
    4 years ago

    Hi FOXYBARK , can you try this (calculated column):

     

     

    sumif ex = 
CALCULATE(SUM('Table'[Count]),FILTER('Table','Table'[Group] = EARLIER('Table'[Group]) && 'Table'[Party] = EARLIER('Table'[Party])))

     

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi FOXYBARK ,

     

    Here I suggest you to create a measure as below.

    How many from Group B,Party equal to Homecoming = 
CALCULATE (
    SUM ( 'Table'[Count] ),
    FILTER (
        'Table',
        'Table'[Group] = "B"
            && 'Table'[Party] = "Homecoming"
    )
)

    Result is as below.

     

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

AnthonyJoseph's avatar
AnthonyJoseph
Icon for Resolver III rankResolver III
4 years ago

Hi FOXYBARK , can you try this (calculated column):

 

 

sumif ex = 
CALCULATE(SUM('Table'[Count]),FILTER('Table','Table'[Group] = EARLIER('Table'[Group]) && 'Table'[Party] = EARLIER('Table'[Party])))