Скачать или смотреть LESSON 10050 | COUNT, COUNTBLANK, COUNTROWS, DISTINCTCOUNT, DISTINCTCOUNTNOBLAK AND THEIR PROBLEMS

In this video, I’ll walk you through the key differences between Power BI’s counting functions—COUNT, COUNTBLANK, COUNTROWS, DISTINCTCOUNT, and DISTINCTCOUNTNOBLANK. You’ll learn how each function behaves when dealing with blank strings, null values, and complete rows, and why it's crucial to understand their inconsistencies to avoid logic errors in your DAX calculations. I demonstrate these behaviors using a sample table and Power BI measures, explaining why COUNT ignores nulls but includes blank strings, while COUNTBLANK counts both. We’ll also explore how DISTINCTCOUNT handles duplicate values and how DISTINCTCOUNTNOBLANK refines the result by excluding blanks. By the end, you’ll know how to apply each function accurately in your reports.

📈 Get the data packs: https://immalytics.com/packs?utm_sour...

🟣 DAX Foundations Playlist: 👉🏻    • DAX FOUNDATIONS  
🟢 Power Query Fundamentals Playlist: 👉🏻    • POWER QUERY COMPLETE FREE COURSE  
🟡 Power BI Playlist: 👉🏻    • POWER BI FROM A TO Z  

💻 For all playlists, visit our website: https://immalytics.com

NULL, WHITE SPACES AND BLANK STRINGS:    • LESSON 10210 | NULL, WHITE SPACES AND BLAN...  
Calculated Comuns vs Measures:    • LESSON 10040 | MEASURES VS CALCULATED COLU...  
All about DAX Structure:    • LESSON 10030 | UNDERSTANDING DAX FORMULA S...  
Iteration:    • LESSON 10130 | ITERATION IN POWER BI AND P...  
Aggregation:    • LESSON 10140 | AGGREGATION OR SUMMARIZATIO...  
Grouping:    • LESSON 10150 | GROUPING IN POWER QUERY: TH...  

Chapters
00:00 Introduction to COUNT functions and their inconsistencies
01:10 Explaining the difference between blank strings and null values
02:00 Importing data into Power BI and checking column positions
02:50 Creating and using a COUNT() measure on the "First Name" column
03:40 COUNT() returns 11 instead of 12 due to one null value
04:40 Editing Excel to include 4 nulls and validating COUNT() result
05:35 COUNT() returns 8, proving it skips nulls but includes blank strings
06:20 Restoring blank strings and COUNT() returns 12 again
06:50 Using COUNTBLANK() to test null counting behavior
07:40 COUNTBLANK() returns 4, showing it counts both nulls and blank strings
08:30 Demonstrating inconsistencies between COUNT and COUNTBLANK
09:20 Warning about incorrect assumptions when switching between functions
10:00 Introducing COUNTROWS() and explaining its table-level behavior
11:00 COUNTROWS() counts all rows regardless of blanks or nulls
11:35 Introducing DISTINCTCOUNT and applying it to the "First Name" column
12:00 DISTINCTCOUNT returns 9 unique values, ignoring repeated names
13:00 Explaining how DISTINCTCOUNT handles blank and null values
14:10 Using DISTINCTCOUNTNOBLANK to exclude blanks from the count
15:00 Testing DISTINCTCOUNTNOBLANK with different combinations
16:10 Comparing results after replacing blanks with nulls
17:10 Confirming that DISTINCTCOUNTNOBLANK excludes only nulls
17:40 Final summary and recommendation to always test COUNT functions
18:00 End of lesson and encouragement to like and share the video

#dax #powerbi #freecourseimmalytics #powerqueryeditor #powerquerycourse #sql #sqlserver