Forum Discussion

TiresAndMore's avatar
TiresAndMore
New Member
2 years ago
Solved

Sum if with two different columns

I know how I would do this in excel with just a couple of sumif statements but I can't get that same result in BI with filters. I have two columns representing Mechanic 2 and Mechanic 3. A mechanic c...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi TiresAndMore ,

     

    I suggest you to create a measure as below.

    Sum if =
CALCULATE (
    SUM ( 'TableName'[Tech Labor $] ),
    FILTER (
        'TableName',
        OR ( 'TableName'[TRANS.MECH2] = 41, 'TableName'[TRANS.MECH3] = 41 )
    )
)

    My Sample:

    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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi TiresAndMore ,

 

I suggest you to create a measure as below.

Sum if =
CALCULATE (
    SUM ( 'TableName'[Tech Labor $] ),
    FILTER (
        'TableName',
        OR ( 'TableName'[TRANS.MECH2] = 41, 'TableName'[TRANS.MECH3] = 41 )
    )
)

My Sample:

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.