Forum Discussion
rosscortb
Post Patron
Post PatronHelp 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
rosscortbPost Patron
Post PatronThats worked. You're the man. :)
themistoklis
Community Champion
Community ChampionAlternatively you can use the following formula without using the FILTER word
Absence Rate = CALCULATE(Count('DB Headcount'[Month]),'DB Headcount'[Month] = "September")