Hey sunindia , Thanks for doing the test. That was helpful.
But I think which method works well that depends on the scenario. In my scenario, max was taking too much time but First load was working good. I was having multiple Facts linked. It was a 10 qv version I guess. May be now in 11 version it is optimized.
But there is also better optimized way to get the max values.