Forum Discussion

benjellounm's avatar
benjellounm
Regular Visitor
5 years ago
Solved

filter by group by

Hi Everyone, I need help creating a group by the table and use it to filter my data. The table has two columns; the name of the firm and Certification type and what I would like to do is create a tab...
Need Help
  • benjellounm's avatar
    benjellounm
    Regular Visitor
    5 years ago

    Thank you very much ğŸ˜Š

  • benjellounm's avatar
    benjellounm
    Regular Visitor
    5 years ago

    one more question is it possible to add a third if statement with the third column?

    I would like to have something like this if the firm is DBE and ESB and Active then ESB-DBE 

    Example

    Firm name |  Certification  |  Status

    Firm A        |  SBE               |   Active 

    Firm B        |  DBE               |  Denied

    Firm A       |  DBE                | Active

     

    Result 


    Firm name |  Certification  |  Status

    Firm A        |  SBE-DBE       |  Active

    Firm B        |  DBE               | Denied

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      5 years ago

       

      New Table V2 =
      ADDCOLUMNS (
      SUMMARIZE(Data,Data[Firm],Data[Status]),
      "@Certification",
      CALCULATE(
      IF (
      { "SBE" }
      IN VALUES ( Data[Certification] )
      && { "DBE" } IN VALUES ( Data[Certification] ),
      "SBE-DBE",
      DISTINCT ( Data[Certification] )
      )
      )
      )