Forum Discussion
Divide Measure - Numerator from One Table and Denominator Table from other Table
Dear Mr. Aj1973,
Finally i got the solution, Thanks you once again, Appreciate if you can share any lilnk to learn abour variable and Dax measures
Community Championthe problem is in Tables COA and Sales
The Ac_key doesn't match in both tables. the Ac_Key = 200 doesn't existe in table COA therefore the sales amount for Acount_Group = Blank()
Dear Mr. Aj1973,
Sorry for Incovenience, I am facing issue in Fixing this problem and hence i have requested for solution from you.
Unfortunately, As advice by you i have fixed the Ac key issue by replaceing the 100 no with 200 to match with COA, However it is still dividing the selected item by total amount, instead of
divided with Sales Volume. Thanking you in advance.
Dear Mr. Aj1973,
Finally i got the solution, Thanks you once again, Appreciate if you can share any lilnk to learn abour variable and Dax measures