Forum Discussion

AJTindall73's avatar
AJTindall73
Advocate I
5 years ago
Solved

filter Table B rows with value from Table A

I have two tables (simplified for my question): Table A (Factual Data) OrganisationalRole DirTeamLink (Directorate Team Link) SalaryView   Table B (Financial Data) DirTeamLink Directorate ...
Need Help
  • tex628's avatar
    tex628
    5 years ago

    What result are you getting if you simply add a selectedvalue() over the salaryview column here? 

    SalaryFilter = IF(and(SELECTEDVALUE(TableA[SalaryView]) = 0, TableB[ExpenseCode] IN {"ExpSal1", "ExpSal2", "ExpSal3"}), 0, 1)

    Br,
    Johannes

tex628's avatar
tex628
Community Champion
5 years ago

What result are you getting if you simply add a selectedvalue() over the salaryview column here? 

SalaryFilter = IF(and(SELECTEDVALUE(TableA[SalaryView]) = 0, TableB[ExpenseCode] IN {"ExpSal1", "ExpSal2", "ExpSal3"}), 0, 1)

Br,
Johannes

  • AJTindall73's avatar
    AJTindall73
    Advocate I
    5 years ago

    You Star! ğŸŒŸ Ah man, it was so simple.... 😫