all of the data where I work ends up many to many, so I use bridging tables a lot and it brings all the benefits of being able to analyze different tables against each other. In power bi you can use bi-directional filtering and relationships but lets not confuse power pivot users. Of all the tricks you shared, learning to use CALCULATE is probably the most important, its just the magic of magic.
Thanks for this post @theexcelclub and the chance to do these learn and earn activities. Im hoping to earn enough steem from them to buy your premium courses. this is such a fantastic idea.
RE: Easy Excel Solutions: Power Pivot Many to Many Relationships