Forum Discussion
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...
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 () ) )
It has changed somewhat, at least it is no longer all zeros, but the percentages are wrong. In the case of OTROS COSTES if we do the operation 9169273 / 170162096, the result should be 5.38% not 0.35%.
tamerj1
Community Champion
Community Championarquironsalud
What is the DAX fro both SALES and COSTS?
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 () ) )