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

     

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