Sum the “Salary" column if "Date" column is blank.

[feehdRXE]

What I'm looking is, to calculate the sum of "Salary", which has no dates in "Date de Desligamento".

  

Many thanks!

[v-xiaotang · Accepted solution]

Hi @feehdRXE 

Thanks for reaching out to us.

You can try this measure,

Measure = SUMX(FILTER('Table',ISBLANK('Table'[Date de Desligamento])),[Salary])

Best Regards,

Community Support Team _Tang

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

[daXtreme]

[Total Salary] =
    SUMX(
        filter(
            T,
            NOT ISBLANK( T[Date de Desligamento] )
        ),
        T[Salary]
    )