Forum Discussion

jtownsend21's avatar
jtownsend21
Responsive Resident
7 years ago
Solved

Column Based on Values From a Measure

I think this is simple, but I cannot figure it out.  I have 2 tables. The first table is my User Table (see example below):    Then I have a Revenue table (see example below):    T...
Need Help
  • jtownsend21's avatar
    jtownsend21
    7 years ago

    Someone else helped me figure this out. I can't take credit. The key was to remove the relationship and use the following measure. 

    Measure =
CALCULATE (
    SUM ( 'Table2'[Amount] ),
    FILTER (
        'Table2',
        'Table2'[Account Manager] = SELECTEDVALUE ( Table1[Employee] )
            || 'Table2'[Consultant] = SELECTEDVALUE ( Table1[Employee] )
    )
)
jtownsend21's avatar
jtownsend21
Responsive Resident
7 years ago

Someone else helped me figure this out. I can't take credit. The key was to remove the relationship and use the following measure. 

Measure =
CALCULATE (
    SUM ( 'Table2'[Amount] ),
    FILTER (
        'Table2',
        'Table2'[Account Manager] = SELECTEDVALUE ( Table1[Employee] )
            || 'Table2'[Consultant] = SELECTEDVALUE ( Table1[Employee] )
    )
)