total part of a column with part of another column

[jonbox]

Hi all, 

I'm trying to work out how to add a aspects of a column together based on another column.

I have several departments with different "scorecard" areas that I want to total up, e.g. for FFR i want to total JUST the ITOT scorecard area, JUST the Manufacturing Plant P2P / GRIR area etc... I want to do the same for other departments too.

So in the example below, I want to calculate all FFR ITOT scores (0.97 + 1 + 0.33) and show it in just one row. same for manufacturing plant p2p, (408 + 1) and show in just one row so it shows JUST the totals per scorecard area. 

Issue is, i don't have a clue on how to do this logically so any help would be very appreciated. 

Thanks in advance. 

[amitchandak · Accepted solution]

@jonbox ,see if these can help

a new column like

Sumx(filter(Table, [departments] = earlier([departments]) && [Magics Scorecard Area] = earlier([Magics Scorecard Area])),[Jul])

or a new measure like

Sumx(filter(allselected(Table), [departments] = max([departments]) && [Magics Scorecard Area] = max([Magics Scorecard Area])),[Jul])

[jonbox]

Thank you very much both for the help. 

[v-yangliu-msft · Accepted solution]

Hi  @jonbox ,

According to your error message:

Your column [Jul] is of String type, you can change it to Decimal number type here:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@jonbox ,see if these can help

a new column like

Sumx(filter(Table, [departments] = earlier([departments]) && [Magics Scorecard Area] = earlier([Magics Scorecard Area])),[Jul])

or a new measure like

Sumx(filter(allselected(Table), [departments] = max([departments]) && [Magics Scorecard Area] = max([Magics Scorecard Area])),[Jul])

[jonbox]

Hey Amit, thanks for the reply.

Unfortunately I've not been able to get your solution to work. I receive issues on both solutions;

With creating the measure i get this issue

and with the new column i have #ERROR on every row.

Any help with this please?