Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
You can create a measure as follows:
TheMeasure = CALCULATE(DISTINCTCOUNT(Table1[Company]),Table1[AmountDue <= 30days]>0)
I hope it worked for you, please accept the suggested measure as a solution
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
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |