Forum Discussion

chenko90's avatar
chenko90
Frequent Visitor
4 years ago
Solved

Summing on multiple rows

Hi, I am trying to create a measure that will sum my values based on two rows. My current formula is:  SUMX(VALUES(Table[customer]),Table[Price Variance])  What i actually need is for the measure ...
sum
SUMMARIZE
sumx
  • amitchandak's avatar
    amitchandak
    4 years ago

    chenko90 , This only need when Price Variance is measure

     

    SUMX(summarize(Table, Table[Product], Table[customer]), "_1", Table[Price Variance]), [_1]) 

     

     

    when price variance is a column

    SUMX(summarize(Table, Table[Product], Table[customer], Table[Price Variance]), [Price Variance])

     

    If this does not help
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

amitchandak's avatar
amitchandak
Super User
4 years ago

chenko90 , This only need when Price Variance is measure

 

SUMX(summarize(Table, Table[Product], Table[customer]), "_1", Table[Price Variance]), [_1]) 

 

 

when price variance is a column

SUMX(summarize(Table, Table[Product], Table[customer], Table[Price Variance]), [Price Variance])

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

chenko90's avatar
chenko90
Frequent Visitor
4 years ago

What does the "_1" mean?