Forum Discussion

RickyTWK's avatar
RickyTWK
New Member
3 years ago
Solved

Count the data from filter rules

Hello, I work from construction company.

I would like to count two type of data which are naming start with "RFI-A" and "RFI-BS"

Can I do this in single column? 

Thank you so much!

 

Tips and Tricks
Tutorial Requests
  • Arul's avatar
    Arul
    3 years ago

    RickyTWK ,

    Try this two measures,

    RFI-A = CALCULATE(
    COUNT('Table (2)'[RFI NO]),CONTAINSSTRING('Table (2)'[RFI NO],"RFI-A"))
    RFI-BS = CALCULATE(
    COUNT('Table (2)'[RFI NO]),CONTAINSSTRING('Table (2)'[RFI NO],"RFI-BS"))

    Thanks,

    Arul

4 Replies

  • Arul's avatar
    Arul
    Super User
    3 years ago

    RickyTWK ,

    Try this two measures,

    RFI-A = CALCULATE(
    COUNT('Table (2)'[RFI NO]),CONTAINSSTRING('Table (2)'[RFI NO],"RFI-A"))
    RFI-BS = CALCULATE(
    COUNT('Table (2)'[RFI NO]),CONTAINSSTRING('Table (2)'[RFI NO],"RFI-BS"))

    Thanks,

    Arul

    • RickyTWK's avatar
      RickyTWK
      New Member
      3 years ago

      The formula not work....

      Am I missing somethings?

      Measure 2 = CALCULATE(COUNT('Issues'[RFI No.],CONTAINSSTRING('Issues'[RFI No.],"RFI-A")))
       
      I provide more information, the column of "RFI. No" have a lot of empty data.
      Only 11 row has value which are RFI-A and RFI-BS
      Thanks!

       

       

      • Arul's avatar
        Arul
        Super User
        3 years ago

        RickyTWK ,

        You are missing close bracket for count and remove one close bracket at the end.
        Put a ) at yellow marked place before the comma and remove bracket at red marked place at the end of the formula..

        Thanks,

        Arul