Adding two tabels

[Anonymous]

Hi 

Below 3 fields is there.

Sales   price

 200      100

Total is :300

Qty

200

300/200

=1.5

 i want like this in power bi please help on this.

[v-lili6-msft]

hi @Anonymous 

You could just create a measure as below to get it:

Result = DIVIDE(SUM(Sales)+ SUM(price) ,SUM(Qty))

If not your case, please share your sample pbix file and your expected output.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Lin

[az38]

@Anonymous 

Column = ([Sales] + [Price])/[Qty]

Unfortunately we can not do more for you with such a poor problem explanation.