Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Correct total for Price Column

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

 

 







 

Need Help
Show and Tell
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi Anonymous 
    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

1 Reply

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    3 years ago

    Hi Anonymous 
    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