Forum Discussion
Difference between New Measure & New Column.
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.
4 Replies
this tutorial with Alberto Ferrari is a good point to start:
https://www.youtube.com/watch?v=klQAZLr5vxA
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-tutorialRegards,
Charlie Liao
Hello
Tried various options but everytime get different results. Attached the file.
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
