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
Icon for Community Champion rankCommunity 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
      Icon for Community Champion rankCommunity 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!