Matching Value in Same Row

[cyborgandy]

abc

[Ahmedx]

or try this

[Ahmedx]

pls try this

[cyborgandy]

Hi @Ahmedx , thanks for your help, issue is in my dataset I also have same value in positive, for example for company ABC i have 3 entries of same amount , 2 of them are in positive and 1 in negative, after this dax its giving matched for positive values , however I want the matched for same negative value with postive value

[Ahmedx]

did you try this variant?

[cyborgandy]

Hey @Ahmedx , I tried the above solution, but the issue is , suppose for ABC company for Jan if i have 3 entries of 5000, 2 of them are +5000 and one of them are -5000, its giving matched for +5000 only, I want one -5000 and one +5000 to show as matched

[Ahmedx]

it works fine