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
Hi aj1973,
I am new to Power bi beginer stage but still manage to create the above income statement, I have sale volume in one table and Income statement in other i want to divide my Sales volume with the Line item and then with Sub line item to ascertain the per unit value, In addition i want to remove the negative sign, Thanking you in advance for your help
Please find enclose below link for my file
https://portals.wetransfer.com/reviews/19866d0a-e442-48f7-b87a-ab4593f0b9b0
Hi 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,
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()