Data model issue

[rajanimaddala]

Hi 

i have 4 tables. 

1. Budgets by product by month

2. Products

3. Date table

4. Sales

i have created the relationships as below

date to sales

date to budgets

budgets to product

sales to product

i need to create a measure as 

total sale value / budget for the month and product. Month is slicer

i am displaying this measure in table.

What is the dax formula for this measure?

[v-yuta-msft]

@rajanimaddala ,

Could you please share the sample data and data structure, the expected output? So I can analysis on your requirement.

Regards,

Jimmy Tao

[amitchandak]

Not sure if I am clear

calculate(divide(sum(Sales[Sales Amount]),sum('Budget'[Budget Value])))

Then if you view data by product and month you should get desired values.