cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
riadorra Regular Visitor
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.

Riad

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: create new SUMIF colum

@riadorra,

 

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
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?

riadorra Regular Visitor
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.

Riad 

Community Support Team
Community Support Team

Re: create new SUMIF colum

@riadorra,

 

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.