Forum Discussion

JoaPalmer's avatar
JoaPalmer
Frequent Visitor
3 years ago
Solved

Finding related subtotals

I have this issue where I cannot find the related subtotals. I have a datasource with these three tables, with simplified contents here:   Project-Sales - Project-ID - Invoice-value   Project-...
Need Help
  • TonyZhou1980's avatar
    TonyZhou1980
    3 years ago

    As per your logic, I think it is simple to solve your problem per below measure,

    Subtotal for Each =
        sumx(
            'Project-Member',
            related('Project-Sales'[Invoice-value])
        )
    Let me know if it works.
TonyZhou1980's avatar
TonyZhou1980
Icon for Resolver I rankResolver I
3 years ago

As per your logic, I think it is simple to solve your problem per below measure,

Subtotal for Each =
    sumx(
        'Project-Member',
        related('Project-Sales'[Invoice-value])
    )
Let me know if it works.
JoaPalmer's avatar
JoaPalmer
Frequent Visitor
3 years ago

This was so much easier solution, thank You very much, works perfect! 🙂