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?
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….