Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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
Anonymous
Not applicable

Hi,

 

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

 

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

Anonymous
Not applicable

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
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors