Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Function Sort by Duplicate

Hello, I'm trying to create a measure to check the occurrence of an ID in two different categories and then classify it as a third category. Ex: [ID]            [BASE] 123145      Table 54845   ...
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Hey, already night my time zone, 21:35 so ping me here tomorrow and we'll do a zoom

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hello SpartaBi,

    Thanks for helping me.

     

    But in this case, it's just checking if the ID is table, correct?

     

    He needs to check if the ID has like two categories HOMEBROKER and TABLE, understand?

    Same ID, can have two categories in the same column.

     

    That is, the same ID will happen more than once in the same column, one of them being MESA and another HOMEBROKER, if so, it will be classified with MHB.

    I even tried to change it here, but I get an error in the number of columns.


    • SpartaBI's avatar
      SpartaBI
      Community Champion
      4 years ago

      Anonymous do you want to show me on zoom/teams?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Yes, I would like a call via Zoom.

        Would be great. Can we do it at 4:30 pm?