Forum Discussion
g_f
3 years agoRegular Visitor
DISTRIBUTE A VALUE ACROSS MULTIPLE VALUES
GOOD EVENING, I HAVE A TABLE OF SKU OF WHICH I HAVE SALES. ON THESE SALES. I CALCULATED WITH THE DAX THE PERCENTAGE SHARE.TO THESE VALUES I HAVE TO ADD A NATIONAL VALUE ( DISTINCT PER SKU) TO DISTRIB...
lbendlin
Super User
3 years agoDo you need to distribute the national numbers across the three cities according to their weight? Does it need to result in integer numbers or are fractions acceptable?