Styjun

Can another character physically take something that Mage Hand is carrying/holding?

How to use JOIN and SUM function to Calculate the total of query returned column?

Why was Mal so quick to drop Bester in favour of Kaylee?

Does “comme on était à New York” mean “since” or “as though”?

Are metaheuristics ever practical for continuous optimization?

Why transcripts instead of degree certificates?

How can I convince my reader that I will not use a certain trope?

Java Optional working of orElse is not as if else

What is the difference between x RadToDeg cos x div and COSC?

How to fix a dry solder pin in BGA package?

Can 'leave' mean 'forget'?

Mean Value Theorem: Continuous or Defined?

Combining two tikz plots together

Was it really unprofessional of me to leave without asking for a raise first?

Can I travel from Germany to England alone as an unaccompanied minor?

Can a police officer film me on their personal device in my own home?

What is the equivalent of Math.Round() with MidpointRounding.AwayFromZero in Delphi?

How can my story take place on Earth without referring to our existing cities and countries?

Who is Johanna in this Joan Baez song - The Winds of the Old Days

Different budgets within roommate group

Did Wakanda officially get the stuff out of Bucky's head?

Why did this meteor appear cyan?

What does grep -v "grep" mean and do?

Should I report a leak of confidential HR information?

Power BI Sum cells grouped by same ID

Excel Formula to Power BI with DAX - Summing multiple values with same IDSum multiple columns using DAX in Power BIpower bi: split column values by character and calculate sumPower BI - Conversion of seconds to hours in DAXSum 2 Table valuesPower BI: DAX formula - build sum on group IDDIVIDE using totals in Power BI – Cost per FTEAdd a Calculated Column to a Table in Power BIPower BI - Create a transaction based table based on inputCalculating Contribution in power BIHow to sum consecutive rows in Power Query

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

How can I make a formula which sums all the cells which have the same ID?

Edit: Both of these columns are in the same table. I need a new column which calculates the sum of all the hours with the same ID.

powerbi

share|improve this question

edited Mar 25 at 12:56

PLATANIUM

asked Mar 25 at 12:31

PLATANIUMPLATANIUM

1,12911 gold badge99 silver badges3232 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Your questions is a bit unclear. Do you have to have a measure or are you happy with a just visual? Are the two columns in the picture in the same table? If not what is their relationship?
  
  – OscarLar
  Mar 25 at 12:52
  

  
  
  
  

add a comment | 

0

How can I make a formula which sums all the cells which have the same ID?

Edit: Both of these columns are in the same table. I need a new column which calculates the sum of all the hours with the same ID.

powerbi

share|improve this question

edited Mar 25 at 12:56

PLATANIUM

asked Mar 25 at 12:31

PLATANIUMPLATANIUM

1,12911 gold badge99 silver badges3232 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Your questions is a bit unclear. Do you have to have a measure or are you happy with a just visual? Are the two columns in the picture in the same table? If not what is their relationship?
  
  – OscarLar
  Mar 25 at 12:52
  

  
  
  
  

add a comment | 

How can I make a formula which sums all the cells which have the same ID?

Edit: Both of these columns are in the same table. I need a new column which calculates the sum of all the hours with the same ID.

powerbi

share|improve this question

edited Mar 25 at 12:56

PLATANIUM

asked Mar 25 at 12:31

PLATANIUMPLATANIUM

1,12911 gold badge99 silver badges3232 bronze badges

share|improve this question

edited Mar 25 at 12:56

PLATANIUM

asked Mar 25 at 12:31

PLATANIUMPLATANIUM

1,12911 gold badge99 silver badges3232 bronze badges

share|improve this question

edited Mar 25 at 12:56

PLATANIUM

asked Mar 25 at 12:31

PLATANIUMPLATANIUM

1,12911 gold badge99 silver badges3232 bronze badges

asked Mar 25 at 12:31

PLATANIUMPLATANIUM

1,12911 gold badge99 silver badges3232 bronze badges

asked Mar 25 at 12:31

PLATANIUMPLATANIUM

1,12911 gold badge99 silver badges3232 bronze badges

1 Answer
1

active

oldest

votes

1

In that case, I would create a new summery table:

SummeryTable = 
SUMMARIZE(
 'TableName';
 'TableName'[ID];
 "Time_summed"; SUM('TableName'[TimeColumn])
)

Then you will end up with a table with distinct [ID] on each row and the sum of all hours corresponding to this ID from the original data table. Which you can use to create a relationship with the original table.

EDIT_1:

Yes you can if you use a calculated column like this:

SumTime = 
VAR thisID = [ID]
RETURN
CALCULATE(
 SUM('TableName'[TimeColumn]);
 ALL('Tablename');
 'TableName'[ID] = thisID
)

share|improve this answer

edited Mar 27 at 6:20

Pang

7,1011616 gold badges6868 silver badges107107 bronze badges

answered Mar 25 at 14:00

OscarLarOscarLar

33811 silver badge1010 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is there a way to do this without a new table? Just with a new column in my existing table with a formula?
  
  – PLATANIUM
  Mar 25 at 14:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is there a way we could speak more directly? I could use more of your knowledge :)
  
  – PLATANIUM
  Mar 25 at 15:19
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Haha thanks @PLATINUM, why not keep the questions here so that everyone can learn from anyone's question. Otherwise I'd have to charge you by the hour for private tutoring ;-)
  
  – OscarLar
  Mar 26 at 7:15
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55337848%2fpower-bi-sum-cells-grouped-by-same-id%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

In that case, I would create a new summery table:

SummeryTable = 
SUMMARIZE(
 'TableName';
 'TableName'[ID];
 "Time_summed"; SUM('TableName'[TimeColumn])
)

Then you will end up with a table with distinct [ID] on each row and the sum of all hours corresponding to this ID from the original data table. Which you can use to create a relationship with the original table.

EDIT_1:

Yes you can if you use a calculated column like this:

SumTime = 
VAR thisID = [ID]
RETURN
CALCULATE(
 SUM('TableName'[TimeColumn]);
 ALL('Tablename');
 'TableName'[ID] = thisID
)

share|improve this answer

edited Mar 27 at 6:20

Pang

7,1011616 gold badges6868 silver badges107107 bronze badges

answered Mar 25 at 14:00

OscarLarOscarLar

33811 silver badge1010 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is there a way to do this without a new table? Just with a new column in my existing table with a formula?
  
  – PLATANIUM
  Mar 25 at 14:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is there a way we could speak more directly? I could use more of your knowledge :)
  
  – PLATANIUM
  Mar 25 at 15:19
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Haha thanks @PLATINUM, why not keep the questions here so that everyone can learn from anyone's question. Otherwise I'd have to charge you by the hour for private tutoring ;-)
  
  – OscarLar
  Mar 26 at 7:15
  

  
  
  
  

add a comment | 

1

In that case, I would create a new summery table:

SummeryTable = 
SUMMARIZE(
 'TableName';
 'TableName'[ID];
 "Time_summed"; SUM('TableName'[TimeColumn])
)

Then you will end up with a table with distinct [ID] on each row and the sum of all hours corresponding to this ID from the original data table. Which you can use to create a relationship with the original table.

EDIT_1:

Yes you can if you use a calculated column like this:

SumTime = 
VAR thisID = [ID]
RETURN
CALCULATE(
 SUM('TableName'[TimeColumn]);
 ALL('Tablename');
 'TableName'[ID] = thisID
)

share|improve this answer

edited Mar 27 at 6:20

Pang

7,1011616 gold badges6868 silver badges107107 bronze badges

answered Mar 25 at 14:00

OscarLarOscarLar

33811 silver badge1010 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is there a way to do this without a new table? Just with a new column in my existing table with a formula?
  
  – PLATANIUM
  Mar 25 at 14:33
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is there a way we could speak more directly? I could use more of your knowledge :)
  
  – PLATANIUM
  Mar 25 at 15:19
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Haha thanks @PLATINUM, why not keep the questions here so that everyone can learn from anyone's question. Otherwise I'd have to charge you by the hour for private tutoring ;-)
  
  – OscarLar
  Mar 26 at 7:15
  

  
  
  
  

add a comment | 

In that case, I would create a new summery table:

SummeryTable = 
SUMMARIZE(
 'TableName';
 'TableName'[ID];
 "Time_summed"; SUM('TableName'[TimeColumn])
)

Then you will end up with a table with distinct [ID] on each row and the sum of all hours corresponding to this ID from the original data table. Which you can use to create a relationship with the original table.

EDIT_1:

Yes you can if you use a calculated column like this:

SumTime = 
VAR thisID = [ID]
RETURN
CALCULATE(
 SUM('TableName'[TimeColumn]);
 ALL('Tablename');
 'TableName'[ID] = thisID
)

share|improve this answer

edited Mar 27 at 6:20

Pang

7,1011616 gold badges6868 silver badges107107 bronze badges

answered Mar 25 at 14:00

OscarLarOscarLar

33811 silver badge1010 bronze badges

SummeryTable = 
SUMMARIZE(
 'TableName';
 'TableName'[ID];
 "Time_summed"; SUM('TableName'[TimeColumn])
)

SumTime = 
VAR thisID = [ID]
RETURN
CALCULATE(
 SUM('TableName'[TimeColumn]);
 ALL('Tablename');
 'TableName'[ID] = thisID
)

share|improve this answer

edited Mar 27 at 6:20

Pang

7,1011616 gold badges6868 silver badges107107 bronze badges

answered Mar 25 at 14:00

OscarLarOscarLar

33811 silver badge1010 bronze badges

edited Mar 27 at 6:20

Pang

7,1011616 gold badges6868 silver badges107107 bronze badges

edited Mar 27 at 6:20

Pang

7,1011616 gold badges6868 silver badges107107 bronze badges

answered Mar 25 at 14:00

OscarLarOscarLar

33811 silver badge1010 bronze badges

answered Mar 25 at 14:00

OscarLarOscarLar

33811 silver badge1010 bronze badges