Forum Discussion

Fistachpl's avatar
Fistachpl
Icon for Helper III rankHelper III
6 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
    6 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]
        )
    )
     
     

     

v-abhinavmu's avatar
v-abhinavmu
Icon for Community Support rankCommunity Support
6 months ago

Hi Fistachpl,

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you for being part of the Microsoft Fabric Community.