In this video, the instructor demonstrates how to use a variety of COUNT functions in DAX, including COUNT, COUNTA, COUNTROWS, and DISTINCTCOUNT.
- [Narrator] Alright, onto some…slightly more interesting functions.…We've got the counting functions in DAX.…So there are four that we're gonna practice here.…Countrows, count, countA, and a new one called distinctcount…which is really, really helpful.…So, countrows, it just counts the number of rows…in an entire specified table or by a table…defined by some sort of expression.…Now, an easy example of that, countrows, reference the table…gives you the total number of rows.…Super simple.…
Next up we've got count.…Count counts the number of cells…in a column that contain numbers.…So all you do is you point the count function…to a column and it returns that number.…CountA is slightly different.…It counts the number of non-empty cells in a column,…so that could include both numerical…or text-based, non-numerical values.…Same exact syntax there.…And finally, distinctcount. Really useful one.…It counts the number of different…cells in a column of numbers.…
So in other words, it counts the uniques.…Same format there. You just point it to a column.…
- Power Pivots versus normal pivots
- Creating calculated columns and measures
- Power Pivot and DAX best practices
- Math, stats, and COUNT functions
- CALCULATE, FILTER, and ALL functions
- Joining data with RELATED
- Using iterator functions (SUMX and RANKX)
- Time intelligence formulas
Skill Level Intermediate
1. Getting Started
Set expectations1m 46s
2. Power Pivot and DAX 101
3. Common DAX Functions
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.