Forum Discussion

jtownsend21's avatar
jtownsend21
Icon for Responsive Resident rankResponsive Resident
7 years ago
Solved

Dynamic Column based on Slicer Selection

I think this is a really simple problem, unfortunately I just don't know how to solve it.  I essentially have 2 tables. The first table is my User Table and it is laid out as follows:    ...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi jtownsend21 ,

     

    You should not create the relationship between the two tables and then create the measure with the formula below.

     

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

    Here is the ouptut.

     

     

    Best  Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
7 years ago

Hi jtownsend21 ,

 

You should not create the relationship between the two tables and then create the measure with the formula below.

 

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

Here is the ouptut.

 

 

Best  Regards,

Cherry