Forum Discussion
Solved
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 = CALCULA...
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
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"))