cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bumble_BEE
Frequent Visitor

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

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("183Unbenannt25.PNG";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

1 ACCEPTED SOLUTION

Accepted Solutions
sduffy Helper I
Helper I

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

Hi,

 

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

 

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

View solution in original post

3 REPLIES 3
sduffy Helper I
Helper I

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

Hi,

 

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

 

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

View solution in original post

Highlighted
bumble_BEE
Frequent Visitor

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

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

bumble_BEE
Frequent Visitor

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

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 

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.