Get field Value based on selection(Field Value) with current selection

[Micki]

Hi folks, 

I have a table :

A	1
A	2
B	4
B	5

And i want select value from second column and put in KPI 

If you User select A: then in one KPI should be value 1 and in another  2 

FieldValue() works but i don't know how to connect it t current selection.

Thank you in advance 

[Micki]

Almost did it, but my code not working fully

Count({<[LastResultOutcome]={'Passed'},
[Level 2] = {"=SubField(concat(distinct Level2, '@'),'@', 7)"}
//[Level2] = {'OEE'}
>}distinct [Id])

Hi , @sunny_talwar, could you please help me how to put SubField(concat(distinct Level2, '@'),'@', 7) in set expression, thank you 

[Micki · Accepted solution]

Ok, it's done 

 [Level2] = {"$(=SubField(concat(distint Level2, '@'),'@', 7))"}

[laacib]

Hi,

I have similar requirement.  I want get the value of field based on selection of another field value.

Could you please explain the above solution? Thanks!