topic How to count the column that contain strings Month in DAX Commands and Tips

How to count the column that contain strings Month

Nyxza — Wed, 22 Feb 2023 08:57:43 GMT

Hi,

I would like to count row that contain month January, then feb and so on. However the data that i have is not structured. Some are January. Some are January- February. Any shortcuts?

Re: How to count the column that contain strings Month

tamerj1 — Wed, 22 Feb 2023 09:24:26 GMT

Hi Nyxza
I hope this is what you're looking for

Please refer to attached sample file with the proposed solution

Month Count = SUMX ( VALUES ( 'Month Filter'[Month] ), COUNTROWS ( FILTER ( 'Table', CONTAINSSTRING ( 'Table'[Month], 'Month Filter'[Month] ) ) ) )

Re: How to count the column that contain strings Month

Anonymous — Wed, 22 Feb 2023 09:34:43 GMT

Column = If( CONTAINSSTRING('Table'[Month], "January") || CONTAINSSTRING('Table'[Month], "February") || CONTAINSSTRING('Table'[Month], "March") || CONTAINSSTRING('Table'[Month], "April") || CONTAINSSTRING('Table'[Month], "May") || CONTAINSSTRING('Table'[Month], "June") || CONTAINSSTRING('Table'[Month], "July") || CONTAINSSTRING('Table'[Month], "August") || CONTAINSSTRING('Table'[Month], "September") || CONTAINSSTRING('Table'[Month], "October") || CONTAINSSTRING('Table'[Month], "November") || CONTAINSSTRING('Table'[Month], "December"), 1, 0 )

Then create a measure in which you can do 2 things to get the countrows of requirement.

Measure2 = CALCULATE( COUNTROWS('Table'), 'Table'[Column]=1)

CountRowsMeasure = SUM('Table'[Column])

Thank you.
If my answer helps you, please mark it as solution.