Pick Match Function - not bypassing selection in Set Analysis

[renuka_sasikuma]

Hi,

I have a field as Unit. When I select Unit, it should not affect my chart.

Tried using this expression : SUM({1}{<Unit=>}Value) along with Pickmatch, also with Pick(Match(Only(Unit)) but it is not working. Any guidance on this.

Unit	Value
1	760
2	50
3	300
Total	1110

Regards,

Renuka S

[anat]

can u try below one using getfieldselection:

if(getfieldselections(DIM2)='A1',Sum({<Dim1=>}Sales)/Count({<Dim1=>}Distinct Date),
if(getfieldselections(DIM2)='A2',Sum({<Dim1=>}Gross)/Count({<Dim1=>}Distinct Date),
if(getfieldselections(DIM2)='A3',Sum({<Dim1=>}Revenue)/Count({<Dim1=>}Distinct Date)
)))