Difference between New Measure & New Column.

[yogeshmaney]

Hello,

Just wanted to know the difference between New Measure & New Column. In the following e.g  wanted a new column to show the count of Column "Category". Added a new measure with formula "COUNTA(Table1[Category])". why it's not giving same result with Add New Column with same formula. 

[v-caliao-msft]

@yogeshmaney,

Calculated columns (and tables) are:

- Evaluated for each row in your table, immediately after you hit 'Enter' to complete the formula

- Saved back into the model so take up space

Calculated Measures are:

- Evaluated when you use it in a visual, when the visual is rendered

- Not saved anywhere (well, actually there's a cache in the report layer but it's not part of the file when you hit Save)

Please refer to the link below to see the details.
http://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
https://projectbotticelli.com/knowledge/dax-calculated-columns-vs-measures-video-tutorial

Regards,

Charlie Liao

[yogeshmaney]

Hello 

Tried various options but everytime get different results. Attached the file. 

Test4Distinct

Need Count of employee. So James on 5th has value 2,2,1

richard 2,2

Ryan 4,4,4,4

James 1

Richard 1

Ryan 1

[yogeshmaney · Accepted solution]

Found solution here.

https://community.powerbi.com/t5/Developer/How-to-count-the-occurrences-of-each-value-in-a-column-in...

[cs_skit]

this tutorial with Alberto Ferrari is a good point to start:

https://www.youtube.com/watch?v=klQAZLr5vxA