- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Help with COUNT and Filter on Text
Hello,
New to BI.
I am looking to count September in a month column.
Can work out the count part but not the filter, can you help please?
Stopped at the below.
Absence Rate = CALCULATE(Count('DB Headcount'[Month],FILTER('DB Headcount') = September
Ross
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So the answer that i posted before will help you create the table.
To provide more details simply create a table and Drag and Drop the Month as Dimension.
Then create a new measure using the formula that i have put in the previous message.
Add the measure to the table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@rosscortb Sample data will be really helpful. I hope you are looking for below DAX.
Absence Rate = COUNTROWS(FILTER('DB Headcount','DB Headcount'[Month] = "September"))
Did I answer your question? Mark my post as a solution!
Proud to be a PBI Community Champion
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks, one other question, how do it get to return the count per rows for each month please?
I thought i could just change the 'Septemer' to [month] but its giving me the overall total count.
Headcount = COUNTROWS(FILTER('DB Headcount','DB Headcount'[Month] = [Month]))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If i understand correctly you want to count the rows per Month. Is this correct?
Why dont you create a table with Month as the Dimension and the Measure will be the following:
Measure = Count('DB Headcount'[Month])
Also if the previous formula posted works ok as well, you can mark it as another correct answer. This will help other users
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have a headcount table with all employees for April, All employees for May etc
And I was creating a column to tell me that there is 2300 employees in April and 2400 in May etc
P.S I have a month table also
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So the answer that i posted before will help you create the table.
To provide more details simply create a table and Drag and Drop the Month as Dimension.
Then create a new measure using the formula that i have put in the previous message.
Add the measure to the table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thats worked. You're the man. 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Alternatively you can use the following formula without using the FILTER word
Absence Rate = CALCULATE(Count('DB Headcount'[Month]),'DB Headcount'[Month] = "September")

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-06-2024 06:05 AM | |||
08-01-2024 02:14 AM | |||
09-26-2024 11:15 AM | |||
05-10-2024 08:03 AM | |||
09-03-2024 09:40 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
47 |