topic Re: Count Specific Text in a Whole Table in DAX Commands and Tips

Count Specific Text in a Whole Table

sup_dome — Thu, 21 Mar 2024 06:05:55 GMT

Hi guys!

I am looking to count the text Unavailable only in the whole table and present it in chart form (bar or pie/donut) with the count only on the "Unavailable" Text. My data is as below:

appreciate suggestions for DAX and methods!

Thank you in advance!

Re: Count Specific Text in a Whole Table

Joe_Barry — Thu, 21 Mar 2024 06:52:15 GMT

Hi sup_dome

When you imported the data was it in that format? I would recommend changing the format from Pivot to Tabular

Go to Power Query
Highlight all columns except Date
Right click and Unpivot selected columns
You should be left with 3 columns Date, a Column with the column Names and a column with the Values
Load the data into the Report view
Create a measure

Unavailable Count = CALCULATE(COUNTROWS(Table), KEEPFILTERS(Table[Values] = "Unavailable")

Thanks

Joe

If you found my answer helpful and it solved your issue, please accept as solution

Re: Count Specific Text in a Whole Table

sup_dome — Thu, 21 Mar 2024 07:48:16 GMT

Thanks Joe! Appreciate it.