Top N Within Matrix Table

HI Jim123456789jim,

>>But the challenge is - The number of "Attempt" is not fixed, the total set can be 2 or 3 or 1. I designed considering only 2. So when it comes in mail, either it is having blank space (when "Attempt1") or Missing data when "Attempt" is more than 2.

You can add visual level filter on group column and switch 'filter mode' to 'topn' with value column as parameter.

>>Hope subscription is the only way to share the Power Bi report in mail.

Current subscription feature only support to send notice email to owner.
For your requirement, I'd like to suggest you to add rule to forward email to other users or submit an idea about improve this feature.
Reference link:

how to set up auto forwarding in outlook 2013

Regards,

Xiaoxin Sheng