Forum Discussion

Fistachpl's avatar
Fistachpl
Icon for Helper III rankHelper III
5 months ago
Solved

Incorrect turnover total

In this topic: Re: Number of Core Products sold through assemblie... - Microsoft Fabric Community we discussed the calculation of amount of products sold through an assemblies. Thanks to FBergamaschi...
  • FBergamaschi's avatar
    FBergamaschi
    5 months ago

    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]
        )
    )
     
     

     

Fistachpl's avatar
Fistachpl
Icon for Helper III rankHelper III
5 months ago

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. 

 

 

 

FBergamaschi's avatar
FBergamaschi
Icon for Super User rankSuper User
5 months ago

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

  • FBergamaschi's avatar
    FBergamaschi
    Icon for Super User rankSuper User
    5 months ago

    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]
        )
    )