DAX Function Sort by Duplicate

[Anonymous]

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        Homebroker
8485          Homebroker
123145      Homebroker
54845        Table

Result
[ID]       [BASE]      [CLASS]
123145 table         MHB 
54845   table        MHB

Could anyone help me?

In short, there are two columns, and every time an ID occurs in MESA and HOMEBROKER it becomes an MHB(Mesa-Homebroker). I would like to create another column with the name MHB and the other empty values.

[SpartaBI]

@Anonymous check out the file sample solution.
Let me know if this is what you meant.
DAX Function Sort by Duplicate 2022-08-04.pbix

      

Showcase Report – Contoso By SpartaBI

[Anonymous]

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]

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

[Anonymous]

Yes, I would like a call via Zoom.

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

[SpartaBI · Accepted solution]

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