I'm trying to create a 'dynamic' measure that sums 'Prod_MRR' based on the opportunity ID. At
I want to create a measure that rolls up the sum of 'Product_MRR' based on opportunity ID. It's worth noting that there are duplicate opp IDs because the table also lists the products attached to the opportunity. For example, opportunity A can have 3 product line items so that opportunity id of A will show up 3 times, but each product only once. In this example, the new measure would show the same value for all 3 records. My end goal is to take the individual 'Product_MRR' values for each row and divide it by the new summed measure to have a '% to Total' field. Last point to make, is i'd like to be able to filter on these product line items on the dash and the summed measure change with the filters.
I was thinking maybe a set analysis but i think i'd have to call out opp ID in order to sum to the opp level.
See screenshot for example. See oppid shows up multiple times, and PGD_MRR is different for each row.
