search and count distincted DN numbers in one columns that are 7 digits long

[Anonymous]

Hello community,

here I am with my next issue. I have following problem which i started with an extra column and a formula unfortunately it brings me no further..

=search("183";lagerbew[LS_Nr.2];1;0)

So i have one column with many different No. of Deliverynotes and Purchasenotes. Now I want to count the different Delieverynumbers in this column. But not dubble ones... 

The DN numbers start with 183... and are 7 digits long.

I tried to work it out with an extra column but actually it makes no sence..

Can anyone help me? Sorry i am still this bloody beginner ... 

thanks in advance already..

bumble_bee

[Anonymous · Accepted solution]

Hi,

This may not be the cleanest solution, but you could try:

Measure = COUNTROWS(DISTINCT(FILTER('Sheet1',Sheet1[lfdnr_ls]>999999)))

[Anonymous]

hey sduffy,

nice and simple smart approach, and yes it works.. I found then also a solution by myself through your idea with >999999:

countax(filter(lagerbew;lagerbew[lfdnr_ls]>999999);["measure"countrows])

However you brought me the solution. thank you very much.. and have a good day

cheers bb

[Anonymous]

to all who might look for the same issue,

i have to correct myself... best solution should be:

=CALCULATE(DISTINCTCOUNT(lagerbew[lfdnr_ls]);filter(lagerbew;lagerbew[lfdnr_ls]>999999);lagerbew[lfdnr_ls])

sorry i was too fast before.. with this solution i do count only all unicque values i want..

thx