Forum Discussion

Anonymous

Not applicable

6 years ago

Adding two tabels

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.

Community Support

6 years ago

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.

Regards,

Lin