topic Avoiding If for the following Expression in App Development

Avoiding If for the following Expression

Ron1 — Tue, 15 Oct 2019 11:25:32 GMT

I do not want to add if else in my expression as we are going through some standards.

Please help me to convert the below expression without If

if(GetSelectedCount([Employee])=1,
avg({<Level={3}, [Department Code]={2}, Country={'India'}>} Target),
if (GetSelectedCount(Department)=1,
avg({<Level={2}, [Department Code]={2}, Country={'India'}>} Target),
avg({<Level={1}, [Department Code]={2}, Country={'India'}>} Target)))

Re: Avoiding If for the following Expression

sunny_talwar — Tue, 15 Oct 2019 11:32:17 GMT

Give this a shot

Pick(Match(1, GetSelectedCount([Employee]), GetSelectedCount(Department)) + 1, Avg({<Level={1}, [Department Code]={2}, Country={'India'}>} Target), Avg({<Level={3}, [Department Code]={2}, Country={'India'}>} Target), Avg({<Level={2}, [Department Code]={2}, Country={'India'}>} Target))

Re: Avoiding If for the following Expression

Ron1 — Wed, 16 Oct 2019 05:15:24 GMT

It works perfectly. Thank you very much.