Forum Discussion

AtchayaP's avatar
AtchayaP
Icon for Helper V rankHelper V
4 years ago
Solved

powerbi

  These are my tables,  Table 1--- skills- > employees have multiple skills, Development item---> Focussed to do in future. In Table 2 and Table 3, you can see there is a relation from Table 1 SKIL...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi AtchayaP ,

     

    I think you can try this code to create a measure to calcualte [Count of Employees from table 1].

    Count of employees from table 1 = IF(HASONEFILTER('Table 3'[Employee name]),BLANK(),DISTINCTCOUNT('Table 1'[Employee]))

    Result is as below.

    Best Regards,
    Rico Zhou

     

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

     

AtchayaP's avatar
AtchayaP
Icon for Helper V rankHelper V
4 years ago

Employee name

skills

arjun

Python, data, excel

rithik

Program, java

edvid

Chemistry,physics,maths,biology

tharun

javascript

elsa

0

jose

0

 

Table 2

Employee name

skills

arjun

Python

arjun

 data

arjun

excel

rithik

Program

rithik

java

edvid

Chemistry

edvid

,physics,

edvid

,maths,

edvid

biology

tharun

javascript

 

Table 3

Employee name

Development items

arjun

Prepare my team

tharun

Training

elsa

mentorship

jose

Workflow

jose

create model

 

This is how my tabel looks, I do not have Development items in table 1. just for explanation, I attached how development item relates to table 3.

 

 

Now can you tell me the possible solution?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi AtchayaP ,

 

I think you can try this code to create a measure to calcualte [Count of Employees from table 1].

Count of employees from table 1 = IF(HASONEFILTER('Table 3'[Employee name]),BLANK(),DISTINCTCOUNT('Table 1'[Employee]))

Result is as below.

Best Regards,
Rico Zhou

 

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