@mussaenda I dont think there is straight forward way to do this but with some DAX measures I believe we can achieve this. Can you share sample data in excel via onedrive/google drive, remove any sensitive data.
Did I answer your question? Mark my post as a solution.
Proud to be a Datanaut! Appreciate your Kudos Feel free to email me with any of your BI needs.