Customers Based on Order History

Hi,Rupak_bi and amustafa ,thanks for your concern about this issue.

Hello,InsightSeeker .I am glad to help you.
Has your problem been solved?
If you have found suitable solutions, please share them as it will help more users with similar problems.
For example, relevant code or links to articles.
Or you can mark the valid suggestions provided by other users as solutions.

By the way, using ISINSCOPE() in the matrix allows you to determine the hierarchy in order to change the output in the MEASUREMENT (for the parent hierarchy you want to change the output)
ISINSCOPE function (DAX) - DAX | Microsoft Learn

Thank you very much for your understanding and support of Power BI.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian