Need to count a column if another has a value (similar to Count if)

[geroagostini]

Hi!

 In the same table ("Table Z") i have 2 columns: Column A and Column B.

 Column A                   Column B

     done                          7261

    approved                    12

     done                          290

     on work                     913

     approved                   6100

     on work                     2000

 I need to count the values of Column B only when Column A is = "done"

 Could someone please help me? 

[FreemanZ · Accepted solution]

hi @geroagostini 

are you expecting a measure like this:

Measure =

CALCULATE(

    SUM(TableZ[Column B]),

    TableZ[Column A] = "done"

)

[geroagostini]

thanks a lot!

[geroagostini]

Why this doesnt work?

Medida 2 = CALCULATE(

   COUNT('Table Z'[Column B]),

   filter('Table Z','Table Z'[Column A]<>"Done"))