Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 |
Solved! Go to Solution.
@Anonymous , Try measure like
sumx(summarize(Table, Table[issuekey], Table[storypoints]),[storypoints])
Add other columns as per need
@Anonymous , Try measure like
sumx(summarize(Table, Table[issuekey], Table[storypoints]),[storypoints])
Add other columns as per need
Hi,
It worked, thank you very much for your help!!!
Best regards
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
95 | |
92 | |
86 | |
69 |
User | Count |
---|---|
162 | |
129 | |
125 | |
104 | |
98 |