cancel
Showing results for
Did you mean:

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Regular Visitor

## 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.

Super User

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 )"