Calculating weights against the entire year with a multi-year table

[Hadrey]

Hi, I need help with create measure to calculate weight of item price relative to 1 year, but I have table with multi-year data something like this

(this is a sample and very simplified table)

ID	NAME	PRICE	YEAR
1	a	200	2023
2	b	300	2023
1	a	100	2024
1	a	540	2023
1	a	300	2023

output for "a" needed to be something like "0,776" for 2023, its be best to be able to filter in visualize by name or id, but a do not need to visual filter by year because I need to use this weight to other measure like weight for 2023 and weight for 2024 at the same time

i'm tired to use answers from other topics but its show's wrong calculations like 2,44 (from orginal model) when should be between 0 and 1

[lbendlin]

0.776? Not really.  More like 0.91.

[Hadrey]

It's 0.776 because it's should by like this

X	A	B	C	D	E
1		2023	2024	WEIGHT 2023	WEIGHT 2024
2	a	1040	100	0,7761	1
3	b	300		0,2239

B2 is sum of all items "a" from 2023 but in D2, the formula looks like this: =B2 / SUM(B2:B3) and I'm need that weight for 2023 and 2024

[lbendlin · Accepted solution]

ok, you can slightly adjust the formula