Embedded Files
Table Of Contents
Table Of Contents
Definition
Definition
COUNTA counts the number of non-blank values in a column, including text, numeric values, and logical values, even counts Boolean values where only Count will not count Boolean data type
Formula
Formula
Number of Reviews = COUNTA('Table'[Review Status])
Use
Use
When you need to count all non-blank values, regardless of the data type (text, numbers, etc.).
Flowchart
Flowchart
Steps
Steps
Go to report view
Insert a card
drag the newly created measure "CountA" from the date pane into card
You will get the CountA displayed in the card
Page updated
Google Sites
Report abuse