Help _ duplicates

[Zakaria_1980]

Hi,

i ve Table with some codes and their Issued POs. as output, I ll need to keep only non duplicated Code & counting for me the issued POs.

i've tried to use the below measure at least to find number of POs issued for those cases with "/", but i didn't succeed to get what i'm looking for as output.

Thanks for your support.

LEN(Local_SubCo_DB[PO Number  ])-LEN(SUBSTITUTE(Local_SubCo_DB[PO Number  ],"/",""))+1

[Zakaria_1980]

very good , now it's working. what is the difference between the two (3O and max lent..) ?

Thanks a lot

[Zakaria_1980]

very good , now it's working. what is the difference between the two (3O and max lent..) ?

Thanks a lot

[Ahmedx · Accepted solution]

show how you wrote, maybe you missed something

also try writing like this:

[Zakaria_1980]

Thanks a lot, when I apply it to my case, I got the following msgerror

[Ahmedx]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RhxWFgowhCzKpxLeN?e=ioWVaK