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
Jaweed
Helper III
Helper III

Distinct Count

Hi experts

 

I am new at PBi and need to extract an aggregate value from my file. I want to know the distinct count of companies which have invoices <=30 days as per table below.

 

 

Company         InvoiceNo         AmountDue <=30days         AmountDue>30days

AAA                   001                   500

AAA                   002                   350

AAA                   003                                                                  225

BBB                    004                                                                  100

CCC                   005                   200

DDD                  006                   100

 

I have 4 invoices which I have been able to extract. Can you help me to get the no of DISTINCT companies. In this case 3 - (AAA CCC and DDD)

 

Thanks

2 ACCEPTED SOLUTIONS
yelsherif
Resolver IV
Resolver IV

You can create a measure as follows:

TheMeasure = CALCULATE(DISTINCTCOUNT(Table1[Company]),Table1[AmountDue <= 30days]>0)

View solution in original post

I hope it worked for you, please accept the suggested measure as a solution

View solution in original post

4 REPLIES 4
yelsherif
Resolver IV
Resolver IV

You can create a measure as follows:

TheMeasure = CALCULATE(DISTINCTCOUNT(Table1[Company]),Table1[AmountDue <= 30days]>0)

Thank you very much.It works perfectly!

Thank you. Let me try.

I hope it worked for you, please accept the suggested measure as a solution

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.