Goal: Count how many sales happened.
Notice how COUNT relies on specific column data, while COUNTROWS just looks at the table.
Ready...
💻 DAX Formula
-- Scenario 1: Count Numbers Only
MEASURE NumSales = COUNT( Sales[Amount] )
-- ⚠️ Ignores Blanks and Text!
-- Scenario 2: Count The Rows (Best Practice)
MEASURE TotalTxn = COUNTROWS( Sales )
-- Counts the row, even if data is missing.