topic Re: DAX Function Sort by Duplicate in DAX Commands and Tips

DAX Function Sort by Duplicate

Anonymous — Thu, 04 Aug 2022 14:26:04 GMT

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.

Re: DAX Function Sort by Duplicate

SpartaBI — Thu, 04 Aug 2022 14:40:24 GMT

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

Re: DAX Function Sort by Duplicate

Anonymous — Thu, 04 Aug 2022 15:28:45 GMT

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.

Re: DAX Function Sort by Duplicate

SpartaBI — Thu, 04 Aug 2022 16:18:03 GMT

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

Re: DAX Function Sort by Duplicate

Anonymous — Thu, 04 Aug 2022 18:04:11 GMT

Yes, I would like a call via Zoom.

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

Re: DAX Function Sort by Duplicate

SpartaBI — Thu, 04 Aug 2022 18:35:39 GMT

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