topic Re: Using sum in a row level - Understanding in Developer

Using sum in a row level - Understanding

Lvmoraes — Thu, 26 Oct 2017 23:10:49 GMT

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

Re: Using sum in a row level - Understanding

Eric_Zhang — Mon, 30 Oct 2017 02:26:46 GMT

@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]))

Re: Using sum in a row level - Understanding

Lvmoraes — Wed, 01 Nov 2017 03:52:36 GMT

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

Re: Using sum in a row level - Understanding

Eric_Zhang — Sat, 04 Nov 2017 08:33:43 GMT

@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])