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] )
    )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi jtownsend21 

 

Have you tried creating a relationship on EmployeeId between the two tables using ManageRelationShip under modelling tab in power bi desktop.

 

Create the slicer of Employees from employeetable.

Then create the table visual from the visualisation pane with the columns from the revenue table.

 

This will work.

 

 

Cheers

 

CheenuSing

jtownsend21's avatar
jtownsend21
Responsive Resident
7 years ago

Anonymous This does not help with the OR statement part of the problem. See Solution below.