Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Count specific text values across Several Columns

Hi Friends,   I have a question about creating a column in Power BI editor table that counts the number of a specific text value across several columns.   See the screenshot below, I would like to ...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Thanks, Hotchilli, 

     

    Here is the screenshot for the error message. It says " ... cannot convert value 11 to Type text". It is the first ID value, which is a numeric field. I have several numeric field, I think the problem is with the numeric fields.  

    So I excluded all numeric fields from the table, and do the formulae again. This time it works perfect.

    See screenshot below.  

    So it seems the formula only works for data with no numeric fields. So if I want to keep my numeric fields in the table, what revision should be made to the formula so it will ignore the numeric fields? 

     

    Thanks,

     

HotChilli's avatar
HotChilli
Community Champion
3 years ago

Post the Error text please.

You click in the Error cell (but not on the word itself)

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks, Hotchilli, 

     

    Here is the screenshot for the error message. It says " ... cannot convert value 11 to Type text". It is the first ID value, which is a numeric field. I have several numeric field, I think the problem is with the numeric fields.  

    So I excluded all numeric fields from the table, and do the formulae again. This time it works perfect.

    See screenshot below.  

    So it seems the formula only works for data with no numeric fields. So if I want to keep my numeric fields in the table, what revision should be made to the formula so it will ignore the numeric fields? 

     

    Thanks,