COUNT vs COUNTROWS - Count table rows in Power BI
There is a key difference between COUNT and COUNTROWS in Power BI. When you want to count all the rows in a table, you should use COUNTROWS instead of COUNT. The reason is that COUNT only considers a specific column and does not account for blank values, while COUNTROWS accurately counts all the rows in the entire table.
Subscribe to stay updated on my new content!
---------------------------------
⏰ TIMESTAMPS
---------------------------------
00:00 Intro
00:26 COUNT does not count BLANK values
01:37 Count vs Countrows with blank values
---------------------------------
😊JOIN
----------------------------------
Website https://www.porcu.bi
LinkedIn / valeriejunk
Bluesky https://valeriejunk.bsky.social/
#powerbi #PowerBITutorial #powerbidesktop #PowerBITraining #powerbitips #Reports #powerbideveloper #PowerBIReports #BusinessIntelligence #DAX #ReportDesign #DashboardDesign