Forum Discussion

IbrahimHakim's avatar
IbrahimHakim
Regular Visitor
4 years ago
Solved

count text values in columns

Please I need your help on this, I have a column of text which I splitted to form 29 resulting columns. So want now to create a measure which will count the the text values in all the columns. Thanks ...
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi IbrahimHakim ,

     

    1. You can create the custom column in Power Query.

     

    = List.Count(List.Select( List.Skip( Record.ToList(_),1), each _ <> null and _ <> ""))

     

    2. Create a measure.

    • Select [Job Posting ID] column, then unpivot other columns.

    • Create the measure.
    Measure = CALCULATE ( COUNT ( 'Table (2)'[Value] ), 'Table (2)'[Value] <> BLANK () )

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi IbrahimHakim ,

 

1. You can create the custom column in Power Query.

 

= List.Count(List.Select( List.Skip( Record.ToList(_),1), each _ <> null and _ <> ""))

 

2. Create a measure.

  • Select [Job Posting ID] column, then unpivot other columns.

  • Create the measure.
Measure = CALCULATE ( COUNT ( 'Table (2)'[Value] ), 'Table (2)'[Value] <> BLANK () )

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.