Forum Discussion

sup_dome's avatar
sup_dome
New Member
2 years ago
Solved

Count Specific Text in a Whole Table

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:   ...
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    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

Joe_Barry's avatar
Joe_Barry
Icon for Solution Sage rankSolution Sage
2 years ago

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's avatar
sup_dome
New Member
2 years ago

Thanks Joe! Appreciate it.