Find the dimension value from measure value.

[poojakaikade]

Hi Team, we have one requirement where we need to find maximum measure value from the list of measure values we get for the particular dimension. 

Dimension names are used to find measure value corresponding to the filter we apply on another dimension. 

After finding the max value for measure , we need to find the dimension for which we got that max measure value. 

Eg - We have applied Group Client filter on dashboard. We need to find possible cluster codes for the applied Group Client Filter. Then we need to find the total eng Ids using those cluster code IDs. Then we need to find maximum count of engagement Ids for the cluster code IDs we got. After that we need to find Cluster code belonging to that max count value of engagement IDs.

[MayilVahanan]

Hi

Try like below in textbox or KPI

=FirstSortedValue(DISTINCT [Cluster code], -Aggr(Count(distinct [engagement IDs]), [Cluster code]))

[poojakaikade]

Hi @MayilVahanan ,

It works. Thanks a lot for the solution.

There is one more requirement in the same.

I need to sort the result in ascending order. How can we apply alphabetical sorting on the above expression using another dimension?

Thanks & Regards,

Pooja