Need help in DAX

Hey Anonymous ,

here you will find a pbix that contains a solution that does rely on data modeling instead of using DAX: https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/EZ1UYqubNL5OrQP-VIdgBEsBF93buB8kEzbOZhVW35sslA?e=Zj62yj

I created a second table using Power Query that looks like this:

Then I creatd a Many-To-Many relationship between both tables like so:

This data model allows to create the visuals you mentioned:

 Hopefully this provides what you are looking for.

Regards,

Tom