cancel
Showing results for
Did you mean:
Regular Visitor

## create new SUMIF colum

Hi,

I have 2 tables, one containing the products ID and other cotaining Sales (Values and Quantity sold) per product ...

On the register table I want to create a new colum with the average sales price price ...

Could anyone help me to solve this SUMIF problem?

thank you.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: create new SUMIF colum

You may check the following DAX.

```Column =
VAR t =
FILTER ( Table2, Table2[productID] = Table1[productID] )
RETURN
DIVIDE (
SUMX ( t, Table2[Quantity] * Table2[Value] ),
SUMX ( t, Table2[Quantity] )
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Super User

## Re: create new SUMIF colum

I'm not sure what this has to do with SUMIF or why you couldn't just create a measure dividing the revenue by the quantity?

Regular Visitor

## Re: create new SUMIF colum

Hi,

based on this new colum, i 'll classificate the products on pre determined ranges following the ranges bellow:

1. sales price from \$0 to \$50

2. sales price from \$51 to \$100

3. sales price from \$101 to \$150

4. sales price from \$151 to \$200

thank you.

Community Support Team

## Re: create new SUMIF colum

You may check the following DAX.

```Column =
VAR t =
FILTER ( Table2, Table2[productID] = Table1[productID] )
RETURN
DIVIDE (
SUMX ( t, Table2[Quantity] * Table2[Value] ),
SUMX ( t, Table2[Quantity] )
)
```
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.