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])))

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi phildavies2022 ,

 

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

 

Hope it helps,


Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.