How to add an expression that will count with a condition

[Phara]

Hi everyone,

I'd like to add an expression that will count the amount IF two conditions are respected :

Condition # 1: column '' Action description'', the value has to be ''Canceled'

Condition # 2: column ''Note'' has to have a value that starts with ''Canceled lign 1''

If the two conditions are respected, then count the amount of values in the dimension ''Sequence number''

Here is a part of the expression that I want to make, I didnt find anything for the condition # 2  with the value starts with ''Canceled lign 1''

=count((if ([Action Description ]='Canceled', [Sequence number])))

Please help!

[hic]

The number of sequence numbers can  be calculated through

count({<[Action Description ]={'Canceled'}, Note={"Canceled lign 1*"}>} [Sequence number])