CALCULATE SUM BY FILTERING BY EXACT DATA

[Syndicate_Admin]

Good morning

I would like to know how I can calculate the sum of a column containing only the data "FEC-" I did so but it is not correct

=calculate(SUM(FAC_QUEST[Valor subtotal local]), FAC_Nor Documento = "FEC-" )

Thank you

[Syndicate_Admin]

Grcias for answering.

I get this

[vojtechsima · Accepted solution]

@Syndicate_Admin , @Diego90 
You're right, check this:

calculate(SUM('FAC_QUEST'[Valor subtotal local]), CONTAINSSTRING('FAC_QUEST'[FAC_Nor Documento], "FEC-" ))

[vojtechsima]

Hi, @Syndicate_Admin 
You're almost there but you are referring to a field that is equal to something, you need to use CONTAINS function:

=calculate(SUM(FAC_QUEST[Valor subtotal local]), CONTAINS(FAC_QUEST, [FAC_Nor Documento], "FEC-" )