Sum of unique values after unpivot

[Anonymous]

Hello, 

I have unpivoted some columns and I got the simplified table below with duplicated issuekey which is normal due to the unpivot (in the real table I have many issuekeys not only DFS-1923).

In my report I need to create a measure that calculates the total number of storypoints and since I have duplicated issuekey I have too many storypoints in my result. How can I sum the storypoints without including the duplicated issuekey? The result in this small table should be 2, not 8.

issuekey	issuetypename	storypoints	FixVersionName	SprintId
DFS-1923	Story	2		17
DFS-1923	Story	2		17
DFS-1923	Story	2		17
DFS-1923	Story	2	DFS-PI3	17

[amitchandak · Accepted solution]

@Anonymous , Try measure like

sumx(summarize(Table, Table[issuekey], Table[storypoints]),[storypoints])

Add  other columns as per need

[Anonymous]

Hi,

It worked, thank you very much for your help!!!

Best regards