Forum Discussion

bflaviu's avatar
bflaviu
Frequent Visitor
9 years ago
Solved

Filter COUNTROWS Where Values Equal Values from Another Table

I am tracking KPIs for some sales reps, so I have a table of all the sales calls they made witih a column that shows what sales method they used (Cold Calls, Meeting, Etc.)  Each sales rep has chosen...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    How about these 2 Measures?

     

    Total Calls = COUNTROWS(SalesCalls)

KPI Method Calls =
CALCULATE (
    [Total Calls],
    FILTER (
        SalesCalls,
        SalesCalls[Method] = RELATED ( 'KPI Settings'[KPI Method] )
    )
)

    EDIT: I used M1 (A) , M2 (B), M3 (C)

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

How about these 2 Measures?

 

Total Calls = COUNTROWS(SalesCalls)

KPI Method Calls =
CALCULATE (
    [Total Calls],
    FILTER (
        SalesCalls,
        SalesCalls[Method] = RELATED ( 'KPI Settings'[KPI Method] )
    )
)

EDIT: I used M1 (A) , M2 (B), M3 (C)

  • bflaviu's avatar
    bflaviu
    Frequent Visitor
    9 years ago

    That worked perfectly!  Thanks!  I was really confused about how the RELATED function worked.  I was getting lost trying to use LOOKUPVALUE function.