Forum Discussion

phildavies2022's avatar
phildavies2022
New Member
4 years ago
Solved

Countif replicate in PowerBI

Hi all,   I've tried all day but give up 😌.  I have 2 tables that have a relationship linked by the Location Code   Table 1: 'ActiveEmployees',[Employee ID] Name, Employee ID, Start Date, End D...
Show and Tell
  • smpa01's avatar
    smpa01
    4 years ago

    phildavies2022  drop    t1[Employee ID] as axis in a viz and drop the following measure

     

    measure = CALCULATE(COUNT(t2[emp code]),TREATAS({MAX(t1[emp code])},t2[emp code]),REMOVEFILTERS(t2))

    one more

    measure2 = CALCULATE(COUNT(t2[emp code]), FILTER(ALL(t2), t2[emp code] in VALUES(t1[emp code])))

     

smpa01's avatar
smpa01
Community Champion
4 years ago

phildavies2022  drop    t1[Employee ID] as axis in a viz and drop the following measure

 

measure = CALCULATE(COUNT(t2[emp code]),TREATAS({MAX(t1[emp code])},t2[emp code]),REMOVEFILTERS(t2))

one more

measure2 = CALCULATE(COUNT(t2[emp code]), FILTER(ALL(t2), t2[emp code] in VALUES(t1[emp code])))