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 ChampionHi mohammedksa
Here you go
your mistake was here
you didn't put the variable you created for the denominator.
when creating VAR have the habbit to add "_" in order not mix between VAR and measures
Dear Mr. Aj1973,
Thanks for the identifying my mistake and also for guiding me for using "_" for measure to differential Var and Measure for my future use. However, the solution provided by is to divide the Line item of Account with Grandtotal, whereas my requirement was to Divided each and every line with the Sales volumen. in my example the Line item is 410, 289, 828.89 / 1,577,873.40 = 258.22, Thanks you advance for your assistance and Guidance,
- aj1973
the 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