Measure Calculation should change dynamically

[jjustingkm]

i have a table like below.

VALUE   METRIC

C            COUNT(ID)

A            AVG(NUM)

Then a chart that change based on expression,  if 'A' is selected that measure should be Avg(num), I give metric in the measure value in the chart but it is displaying as 'Avg(num)'.

Thanks,

[jwjackso]

Using this data.

Metric:
load * Inline [
Value,Metric
C,Count(ID)
A,AVG(NUM)
];

Data:
Load * Inline [
ID,NUM
1,100
1,200
2,200
3,300
];

If 'A' is selected

When 'C' is selected

When nothing or both are selected