Forum Discussion

seanpratt's avatar
seanpratt
Helper III
2 years ago

DAX Formula Help

I'm not sure how to phrase this, but I'm simply looking to sum up the story points by each Work Item ID. When I aggregate all of our story points for a sprint in Power BI, it's saying ID 21822 is wor...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi seanpratt ,
Based on your description, the data you are displaying is duplicated across columns, which results in automatic aggregation when displayed. If you want to display only the values of each item, unaggregate them in the visual object

Or you can create a measure

Story Points_ = 
CALCULATE(
    AVERAGE('Table'[Story Points]),
    ALLEXCEPT(
        'Table',
        'Table'[Work Item ID]
    )
)

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly