Forum Discussion

markblom's avatar
markblom
Frequent Visitor
3 years ago
Solved

Combine data from hierarchy

Hi,   Let's say I have these 3 tables:   Article ArticleId ArticleCode ArticleSecondary PrimaryArticleId SecondaryArticleId This table is the link between a Primary Article with zero, o...
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi markblom 

    please try

    Quantity Ordered For Secondary Article =
    CALCULATE (
    SUM ( Orders[Quantity] ),
    USERELATIONSHIP ( ArticleSecundary[SecondaryArticleId], Orders[ArticleId] ),
    CROSSFILTER ( Article[ArticleId], Orders[ArticleId], NONE )
    )

markblom's avatar
markblom
Frequent Visitor
3 years ago

Thanks for the reply! I will have a look at the youtube movies in your links.