Forum Discussion

tanvi_m's avatar
tanvi_m
Frequent Visitor
6 years ago
Solved

Repeated Text in Cell

In my Power BI one row table, I have a cell with multiple entry of words AA and BB with prefix of new. I need to count how many times each (AA and BB) are associated with new. For example in below ex...
Need Help
Show and Tell
Tips and Tricks
  • parry2k's avatar
    parry2k
    6 years ago

    tanvi_m interesting I'm getting 2 for both AA and BB from your sample data.

parry2k's avatar
parry2k
Super User
6 years ago

tanvi_m try following measures

 

AA Count = CALCULATE( COUNTROWS ( 'Table' ), CONTAINSSTRING ( 'Table'[Text], "AA" ) )

BB Count = CALCULATE( COUNTROWS ( 'Table' ), CONTAINSSTRING ( 'Table'[Text], "BB" ) )
tanvi_m's avatar
tanvi_m
Frequent Visitor
6 years ago

Thankyou parry2k , but using this formula I am getting 1. Even tried replacing "AA" with "*AA*". Result still remains the same 

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    tanvi_m interesting I'm getting 2 for both AA and BB from your sample data.

    • tanvi_m's avatar
      tanvi_m
      Frequent Visitor
      6 years ago

      Not sure, where I am doing wrong then. Sent you snapshot of my calculation and result with 1 . Please let me know if any miss there, 

      Thanks