How to compare multiple rows for a given column

Hello Anonymous 

Below are two variants. 1st is what you showed as per your last post and 2nd is as per your 2nd post. You can choose any one. PowerBI file is attached.

Feel free to accept as solution so that others find it easy to get solution.

Thanks,

www.thingsclump.com

Hi

I believe you need a bridge table to resolve this. You can create a table (let's call it bridgetable) with unique IDs. Create a relationship with bridgetable and table with all metric values. This relationship will be 1 to many.

Thanks