Correct total for Price Column

[mg01]

Hi Team,

Above is my table, by which I'm creating a table visual with Product and Price column but price total is not coming correct, For example, for A it should be 2, For B it should be 3. But on summarizing it giving 4 for A, 6 for B. Is there any way by which we can achieve this.

Required O/P: Total should be 5, Price value should be 2 for A, 3 for B, it should not aggregate like 4 for A, 6 for B. And also I need total in this visual.

Thanks,
Mohit

[Ritaf1983 · Accepted solution]

Hi @mg01 
You need to summarize the price in a way that will calculate only 1 appearance to get accurate results.
So create a measure with the formula :

SumPrice = sumx(VALUES('Table'[Product]),FIRSTNONBLANK('Table'[Price],0))

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