Thanks for the quick reply.
This approach is good for 2-3 measures and a small dataset. I have quick heavy data file and more than 10 measures to create. I don't think this approach will help me in achieving the goal.
If that's the case, you need to use ETL tool or simply combine multiple sheets on dashboard. .