I noticed you didn’t provide a PBIX file. Providing one will help users and experts find a solution to your inquiry faster and better.
A perfect initial question includes all of the following:
A clear explanation of the problem you are experiencing
A mockup of the results you want to achieve
Your current work-in-progress PBIX file
Your underlying data file (to allow us to go into Power Query if necessary to transform your data and/or data model – often DAX questions really end up being data modeling solutions)
To close this thread, please Select the reply that solves your question (for this instance please select your previous reply) click the three dots beside Reply and then tick the checkbox beside solution.
Thank you very much for posting your question here in the Forum. If it is OK with you, we hope you can share with us the reply you’ll receive from Microsoft.