calculate filter with variable and special char

[nicolast29]

Hi, i have to filter accounting accounts for my calculation 

W102 =CALCULATE ([solde],FILTER ('GL Normé',

'GL Normé'[CompteNum]>= 707####0

&& 'GL Normé'[CompteNum] <= 707####0

))*-1

Here the # means all numbers between 0 and 9

I try that but i want something more smooth, for my next case more complex

W102 =

CALCULATE (

[solde],

FILTER (

'GL Normé',

VALUE(LEFT('GL Normé'[CompteNum],3))= 707

&& value(RIGHT('GL Normé'[CompteNum],1)) <> 0

)

)*-1

Thanks nicolas

[v-yalanwu-msft]

HI, @nicolast29 ;

Is your problem solved? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi, @nicolast29 ;

You could try it.

W102 =
CALCULATE (
[solde],
FILTER (
'GL Normé',
LEFT('GL Normé'[CompteNum],3)= '707'
&& RIGHT('GL Normé'[CompteNum],1) <> '0'
)
)*-1
 

I'm not sure what you're looking for, but it would be nice if you could give an example and output what you want to see

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.