function in set analysis is ignoring table dimension

[shaybitton]

Hi All,

I have a data set with values and descriptions, for example:

value          description

1                LOW

2                MEDIUM

3                HIGH

I need to calculate the average and display the description, for example the average is 2 I need to display medium.

I tried to use the function:

Only( {$<[Monitoring Value]={'$(=Floor(AVG({<Source={'Monitoring'}>}[Metric Value for avg])))'}>}[Metric Name])

but it doesn't work for all the values.

I tried with aggr but it doesn't work for all cases as well.

Maybe someone has any idea?

Thanks,

Shay

[sunny_talwar]

May be try this:

Pick(Floor(Avg({<Source={'Monitoring'}>} [Metric Value for avg])), 'LOW', 'MEDIUM', 'HIGH')

[shaybitton]

Hi Sunny

Thank you for your response,

The problem is, that  the value of low, high or medium was only for example, and I have about thousands of metric names, so I can't do It with hard coded.

Any alternative solution?

Thanks,

Shay