Distinct Count

[Jaweed]

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

[yelsherif · Accepted solution]

You can create a measure as follows:

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

[yelsherif · Accepted solution]

You can create a measure as follows:

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

[Jaweed]

Thank you very much.It works perfectly!

[Jaweed]

Thank you. Let me try.

[yelsherif · Accepted solution]

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