The 365 Power BI Course - Calculated Column Vs Measure...
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 answers ( 0 marked as helpful)
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.