Sumif in Power BI?

Hi engyin2,

I test it using your sample table and get expected result. You need to create a measure using the formula below.


In excel, the result

Result =
CALCULATE ( SUM ( Table1[$] ), FILTER ( Table1, Table1[Project] = "A" ) )
    + CALCULATE ( SUM ( Table1[$] ), FILTER ( Table1, Table1[Project] = "B" ) )

Create a card to display the measure value. You will  get the right result as follows.



Best Regards,
Angelia