DAX Average

[Michnia25]

Hi,
I am new to Power BI, so I apologize if the question is trivial.
I try to run the Average formula, but the outcome percentage is not right, due to a duplicate line, is there any way to avoid that issue?
I need a formula to first calculate the average for the particular line and then the average of the total.

I will appreciate the support.

Kamil

 

[Michnia25]

Any ideas on how to resolve the problem, will be appreciated.

 

[JGordon11]

In Power Query:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    tbl = Table.Group(Source, {"Item"}, {{"Avg", each List.Average([Pct]), type number}}),
    rcd1 = [Item = "Average by Item", Pct = List.Average(tbl[Avg])],
    rcd2 = [Item = "Average All", Pct = List.Average(Source[Pct])],
    tbl1 = Table.FromRecords(Table.ToRecords(Source) & {rcd1} & {rcd2}),
    Result = Table.TransformColumnTypes(tbl1,{{"Pct", Percentage.Type}})
in
    Result

PQ Average by item.xlsx
	A	B	C	D	E	F
1	Item	Pct		Item	Pct
2	1	24%		1	24%
3	1	29%		1	29%
4	2	67%		2	67%
5	3	84%		3	84%
6	4	61%		4	61%
7	4	78%		4	78%
8	5	91%		5	91%
9	6	59%		6	59%
10				Average by Item	66%
11				Average All	62%
12
Sheet1