Forum Discussion

DarylRob's avatar
DarylRob
Icon for Helper I rankHelper I
4 years ago
Solved

Pull data into matrix when datas only in the second table

Hi,    So I've created a matrix with the below columns   Table1.Account Manager Name, Table1.Client Name, Table1.Client Office, Table1.Revenue1, Table2.Revenue2 The two tables have the below dat...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi DarylRob ,

    I created a sample pbix file(see attachment) for you, please check whether that is what you want.

    1. Create the relationship base on the field Account Manager Name

    2. Create a measure as below to get the revenue2

    NRevenue2 =
CALCULATE (
    SUM ( 'Table2'[ Revenue2] ),
    FILTER (
        'Table2',
        'Table2'[ Client Office] = SELECTEDVALUE ( 'Table1'[ Client Office] )
    )
)

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi DarylRob ,

I created a sample pbix file(see attachment) for you, please check whether that is what you want.

1. Create the relationship base on the field Account Manager Name

2. Create a measure as below to get the revenue2

NRevenue2 =
CALCULATE (
    SUM ( 'Table2'[ Revenue2] ),
    FILTER (
        'Table2',
        'Table2'[ Client Office] = SELECTEDVALUE ( 'Table1'[ Client Office] )
    )
)

Best Regards