Reg: selected column to display respected values

[Anonymous]

Hi everyone,

i have two columns

A B

a 100

b 200

c 300

now if i drill through based on column A fields then i can display based on selected value.ex: if drill through using field 'a' then i can display 'a' in the card by using selectedvalue(column name).

but now my requirement is if i drill though based on field lets say 'a' then i need to display respected value i.e 100. how to do that?

[Tahreem24 · Accepted solution]

@Anonymous , create a measure like below:

Measure = CALCULATE(SUM('Table'[B]),FILTER('Table','Table'[A]=SELECTEDVALUE('Table'[A])))