Forum Discussion

arquironsalud's avatar
arquironsalud
Regular Visitor
3 years ago
Solved

DIVIDE two tables measure

I turn to the wisdom of this forum because I have a question that I can not solve and I'm going crazy. I am going to describe the structure of my data and then I will explain the problem I have. If y...
"DAX"
"Need Help"
  • arquironsalud's avatar
    arquironsalud
    3 years ago

    Hello,
    Thanks for your point, it has led me to find a solution. There is a slight difference. The formula that worked for me was:

     

    PESO =
    DIVIDE ( [COSTS], CALCULATE ( [SALES], ALLSELECTED () ) )

andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

The problem is your data model in my opinion. You use "1 DIG" for the relationship and also as a filter criteria in your DAX formula. You need a relationship via the "AGGREGATOR RATIOS". Than you are able to calculated for each RATIOS the correct Costs and sales. Perhaps you have to transform your data. Perhaps some sample data will help to understand the data structure.