How to calculate Average Invoice value for invoices above 2 lakh

[B_kumar]

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

[amitchandak · Accepted solution]

@B_kumar , Try a measure like

sumx(filter(Summarize(Table, Table[Invoice No], "_1", calculate(Sum(Table[Amount]))),[_1]>200000),[_1])