Forum Discussion
Incorrect turnover total
Got it sooner than expected
Attached the v4 version with this result
Started from your v3 (previous post) and changed only the DAX
We could discuss the relationship Basuc price - dim Product, but I did not change that this time
_to2 =SUMX (VALUES ( 'dim Products and Assemblies'[Catalogue No]),CALCULATE(([Test Sold Direct]+[Test])*[_price]))
Hi Fistachpl
the problem was due to the the relationship set
The situazion was that you had a many to one relationship between Basic product pricelist and dim Product and Assembly. I changed it into a one to many (it is in reality a 1 to 1 but as you have done, you can force that to many to one or one to many, I just forced it on the opposite direction so Basic product pricelist becomes a dimension)
Now I get this
File attached
In this way, the _price measure becomes:
FBergamaschi but the problem is, that values in green are correct, just the SUM is not:
the turnover should be calculated on the base of direct sales + sales through assemblies not as in this case where we have: direct sales + assembly sales (orange rectangle):
These values 137,50, 168 and 216 should be "distributed" over the basic products.
Got it, give me a couple of days to fix that
The logic must be the same as the other measures I created
Thanks
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Got it sooner than expected
Attached the v4 version with this result
Started from your v3 (previous post) and changed only the DAX
We could discuss the relationship Basuc price - dim Product, but I did not change that this time
_to2 =SUMX (VALUES ( 'dim Products and Assemblies'[Catalogue No]),CALCULATE(([Test Sold Direct]+[Test])*[_price]))