When To Use The CALCULATETABLE Function - DAX Function Techniques [2022 Update]

Very good. Thank you.
People ask me what does power bi do. I try and explain that in simple terms it allows you to create pivot tables, that then influence (filter) cascading pivot tables to give you an intersection of attributes that you want to look at (of course, it's a whole lot more than that). Your example here is excellent! The biggest gain I see is what you mention, it gives readability and easy interpretation of the logic in the DAX code.

Hello Sam, the logic that you use to solve the problem helps me understand more about the use of this function.... Greetings from Mexico.