Forum Discussion

Jaweed's avatar
Jaweed
Helper III
7 years ago
Solved

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    ...
Need Help
  • yelsherif's avatar
    yelsherif
    7 years ago

    You can create a measure as follows:

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

  • yelsherif's avatar
    yelsherif
    7 years ago

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

yelsherif's avatar
yelsherif
Resolver IV
7 years ago

You can create a measure as follows:

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

Jaweed's avatar
Jaweed
Helper III
7 years ago

Thank you very much.It works perfectly!