Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
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
this tutorial with Alberto Ferrari is a good point to start:
https://www.youtube.com/watch?v=klQAZLr5vxA
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |