The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Ask
Anybody can ask a question
Answer
Anybody can answer
Vote
The best answers are voted up and moderated by our team

The 365 Power BI Course – Calculated Column Vs Measure…

The 365 Power BI Course – Calculated Column Vs Measure…

0
Votes
1
Answer

Hi 365 Data Science team, In Power Bi If Calculated columns work at Row level than when we calculated Sum population column why it gave the sum of whole column as answer in all rows?

1 Answer

365 Team
0
Votes

Hey Renu, it works like this. You are telling the engine give me the SUM of Population column. It sums it up and returns a value. Because it is a calculated column, it cannot insert the value on the first row and keeps adding the same value for each row until we reach the end of the table.

Thanks! Dimitar Shutev….

6 months