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

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

arquironsalud 
What is the DAX fro both SALES and COSTS?

arquironsalud's avatar
arquironsalud
Regular Visitor
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 () ) )