Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Adding Kit Component Costs to Compare

I am brand new to Power BI and am trying to match soon to be outdated company reports. One of the services we provide is product kits comprised of several other kits. The only functionality I am unab...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

You may modify the measure using dax below:

TTL CC of Components =
CALCULATE (
    SUMX (
        vwFactKitComponentCurrent,
        vwFactKitComponentCurrent[Quantity]
            * RELATED ( DimInventoryItemComponent[ComponentCurrentCost] )
    ),
    ALL ( DimInventoryItemComponent )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-yuta-msft 

     

    The issue is that now returns every component number in the component table for each master number even though the relationship table has relationships defined.

     

    When I don't include this measure, the components are properly listed.