Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to get the correct Table Total

  I've spent 3 hours on this simple calculation but I just couldn't get it straight. So I have two tables,   one is 'DeVore referrals", Which has columns [Group name] and [account Numbe...
  • Nathaniel_C's avatar
    Nathaniel_C
    7 years ago

    Anonymous ,

    Below are my two tables designed from your description, very nice. Then the relationship. And my pbix Groups

     

    Note that I included one account number not assigned to a group.

     

    Please let me know if you have any questions.

     

     

    If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
    Nathaniel

     

     

     

    f

     

    l

     

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
7 years ago

Hi Anonymous ,

Please see the picture below, and the measure.

 

Let me know if you have any questions.

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

 

Group total = CALCULATE(SUM('AUM DETAIL'[Gross]) ,FILTER('AUM DETAIL','AUM DETAIL'[Account num]))

 

Nathaniel_C's avatar
Nathaniel_C
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous ,

Below are my two tables designed from your description, very nice. Then the relationship. And my pbix Groups

 

Note that I included one account number not assigned to a group.

 

Please let me know if you have any questions.

 

 

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

 

 

 

f

 

l