Sam,

Please advise how to compute the sales per square feet by branch and total. Currently, the measure which I have used gave me sales per sq ft based on the total branch floor area, instead of by branch. I have the following datasets:-

**Daily Sales table**

Cost centre Date Amount

**Branch floor area**

Branch Cost centre Trading Area (Sq ft)

Measure which I have used are as follow:-

Total sales= sum(sales amount)

Total Branch floor area= sum(branch floor area)

Average sales= Averagex(values(‘Date’[MonthnYear]), [Total sales])

Sales per sq ft= Divide( [Average sales], [Total Branch floor area)]

Thanks.