Using sum in a row level - Understanding

[Lvmoraes]

Hello,

Can you please help me understanding how an aggregation function works on a row level? ( Sum for example )
I thought it would behave like Excel, but this is what happens ( it summarizes everything on each row):

Just trying to understand, thank you very much

Lucas

[Eric_Zhang]

---

@Lvmoraes wrote:

Hello,

Can you please help me understanding how an aggregation function works on a row level? ( Sum for example )
I thought it would behave like Excel, but this is what happens ( it summarizes everything on each row):

Just trying to understand, thank you very much

Lucas

---

@Lvmoraes

What do you mean "in a row level"? If you refer to "product" level, you can try

SumColumn = CALCULATE(SUM(MapProds[Tax]),ALLEXCEPT(MapProds,MapProds[Product]))

[Lvmoraes]

Hi Erik,

not really, the question actually is why the sum is not summing the values for that record? Example:

Product  Tax  Sum(Tax)

Belt          0        0

Hat          1        1

Instead, it will ignore the row and sum the total, like:

Product  Tax  Sum(Tax)

Belt          0        1

Hat          1        1

It's the red 1 I don't get.

Your example is really cool, I will accept it as correct... but if you can just confirm that's how PowerBI behaves if you try to Aggregate at a column, would be fine.

Kind regards,

Lucas

[Eric_Zhang · Accepted solution]

---

@Lvmoraes wrote:

Hi Erik,

not really, the question actually is why the sum is not summing the values for that record? Example:

Product  Tax  Sum(Tax)

Belt          0        0

Hat          1        1

Instead, it will ignore the row and sum the total, like:

Product  Tax  Sum(Tax)

Belt          0        1

Hat          1        1

It's the red 1 I don't get.

Your example is really cool, I will accept it as correct... but if you can just confirm that's how PowerBI behaves if you try to Aggregate at a column, would be fine.

Kind regards,

Lucas

---

@Lvmoraes

If you mean measures in a chart, it's all about context. See

total = SUM(yourTable[Tax])

totalAll = SUMX(ALLSELECTED(yourTable),yourTable[Tax])