Help with the DAX formula from detailed kpi value to summarized data

[Anonymous]

From report 1(detailed report) there is a kpi already in place performance%,  now i want a kpi for report 2 at summarized level.
want to see the percentage at sold to and store level, by doing an average on performance%.
Can you help me with the formulae. 

Note : Performance% is a measure

@amitchandak

Report1
Sold-To	Store name	Material	Performance%
BBB	BBB AM	M1	100%
BBB	BBB AM	M2	100%
BBB	BBB AM	M3	86%
BBB	BBB AM	M4	86%
BBB	BBB AM	M5	74%
BBB	BBB AM	M6	40%
BBB	BBB AM	M7	23%
BBB	BBB AM	M8	14%
BBB	BBB AM	M9	0%
BBB	BBB AM	M10	0%
		AVG	52%
JB	JB H	M1	80%
JB	JB H	M2	90%
		avg	85%
Report 2
Sold-To	Store name	Performance %
BBB	BBB AM	52
JB	JB H	85

[v-jialluo-msft · Accepted solution]

^{Hi @Anonymous ,}

^{Please follow these steps:}

^{(1) Create a new measure}

AVG =

DIVIDE (
    SUM ( 'Table'[Performance%] ), COUNT ( 'Table'[Store name] )
)

^{(2)Final output}

^{Since I don't have specific sales data, I use measures as attribute columns, and you can replace them with sales columns yourself.}

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}