Forum Discussion

DariusBD's avatar
DariusBD
Regular Visitor
4 years ago

Relative and current price

Hey people, I'm very new in PowerBi and hope someone could help me. 

In this table I got relative and current sum sales by products.

I use:

•Relative sales = CALCULATE(SUM(sale[sale_no_tax]), ALL(RelativeTime))

•Current sales = CALCULATE(SUM(sale[sale_no_tax]), ALL('Time'))

I need:

Add relative and current product price.

I was trying use - Relative price = CALCULATE(SUM(sale[product_price]), ALL(RelativeTime))

But is problem, example product price is 2€ and if product was sold two times in day I get 4€ a sum price.

Was trying without sum but it just not work, have no  more idea's how to do.

So maybe someone could help me please.

1 Reply

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi DariusBD 
    You may try

     

    Relative price =
CALCULATE (
    SUMX ( VALUES ( sale[product_code] ), MAX ( sale[product_price] ) ),
    ALL ( RelativeTime )
)

     

    However, I do not understand the use of "ALL ( RelativeTime )"