Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I am new to Dax and trying to calculate average Invoice value for invoices above 2 lakh, please help.
Invoice No | Date | ITEM | Amount |
2020-21/001 | 09-10-2020 | A | 70000 |
2020-21/001 | 09-10-2020 | B | 60000 |
2020-21/002 | 09-10-2020 | D | 45000 |
2020-21/002 | 09-10-2020 | A | 70000 |
2020-21/002 | 09-10-2020 | C | 90000 |
2020-21/002 | 09-10-2020 | B | 60000 |
2020-21/003 | 09-10-2020 | A | 70000 |
2020-21/004 | 09-10-2020 | A | 70000 |
2020-21/004 | 09-10-2020 | B | 60000 |
2020-21/004 | 09-10-2020 | D | 45000 |
2020-21/005 | 09-10-2020 | D | 45000 |
2020-21/006 | 09-10-2020 | A | 70000 |
Solved! Go to Solution.
@B_kumar , Try a measure like
sumx(filter(Summarize(Table, Table[Invoice No], "_1", calculate(Sum(Table[Amount]))),[_1]>200000),[_1])
@B_kumar , Try a measure like
sumx(filter(Summarize(Table, Table[Invoice No], "_1", calculate(Sum(Table[Amount]))),[_1]>200000),[_1])
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |