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 () ) )

arquironsalud's avatar
arquironsalud
Regular Visitor
3 years ago

Hi, the relationship between both tables is ACCOUNTS[15 DIG] with BALANCES[ACCOUNT 15], not "1 DIG". Thanks

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

    My fault sorry! But in your matrix you use "1 DIG" as a column. Can you remove it?