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

     

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

Hi Fistachpl,

Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to FBergamaschi  for sharing valuable insights.

 

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you for being part of the Microsoft Fabric Community.