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:

 

appreciate suggestions for DAX and methods!

 

Thank you in advance!

 

  • 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

2 Replies

  • 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