Forum Discussion

PBIFX200's avatar
PBIFX200
New Member
5 years ago
Solved

Calculated table based on 2 different tables.

Hello everyone,    Newbie here! Any help would be very much appreciated!   Table 1 (unique ID) Net amount based on uniques ID ID  net 1 200 10 -300 8 -60 9 100 12 150 ...
Calculatetable
Measures
PBI
tables
CNENFRNL's avatar
CNENFRNL
Community Champion
5 years ago
= CALCULATE( SUM( Table1[net] ), CALCULATETABLE( Table2 ) )

PBIFX200's avatar
PBIFX200
New Member
5 years ago

Thank you so much CNENFRNL for the quick reply. I'm looking for the same result but as a table in The Data tab not in report tab. I was able to the same thing. The challenge here is to Create a New table from 2 different tables

 

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion
    5 years ago
    Table3 = 
SUMMARIZECOLUMNS(
    Table2[Employee or team],
    Table2,
    "Sum", SUM( Table1[net] )
)

    • PBIFX200's avatar
      PBIFX200
      New Member
      5 years ago

      Thank so much CNENFRNL for your reply, I don't want to take advantage of your kindness. but if I want to build on your first reply 

      I want to create a slicer with 2 bottons (top 5 bottom 5) when I select top 5 the green part will be selected and when I select bottom 5 the red part will be selected.

      by the way, the below table is the same as the one right above but ranked this time!

       

      if you could help with this I will be very grateful. whenever you are free! thanks again!

       

       

       

      • CNENFRNL's avatar
        CNENFRNL
        Community Champion
        5 years ago

        There are ties in ranking,