Get the Values who has maximum number of occurences

[ishanbansal1204]

Hi Experts,

I have a dataset,

Dim A	Dim B	Value	Total Count	Row Level count
W907	1236772	22.37	304	264
W907	1236772	20.8	304	40

In this scenario, I want to display only one record for Dim A, Dim B based on the row level count

1. Display value for the row level count which has maximum number in the above case 264 is highest so 22.37 should be the output

2. If both the row level count values are same then display the minimum of Value

Please help.

Want to have this in load script.

[PriyankaShivhare · Accepted solution]

may Be like This

aggr(min(if(aggr(nodistinct max([Row Level count]),[Dim A],[Dim B])=[Row Level count],Value)),[Dim A],[Dim B])

Thanks,

Priyanka

[ishanbansal1204]

Thank you very much.

[ishanbansal1204]

Hi Priyanka,

Is there a way I can use this function in Load script rather than a measure.?

Thanks