Count Specific Text in a Whole Table

[sup_dome]

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!

[Joe_Barry · Accepted solution]

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

[sup_dome]

Thanks Joe! Appreciate it.