Forum Discussion

rajanimaddala's avatar
rajanimaddala
Helper II
6 years ago

Data model issue

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?

 

Need Help
Tips and Tricks

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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.

     

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    rajanimaddala ,

     

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

     

    Regards,

    Jimmy Tao