Forum Discussion

AtchayaP's avatar
AtchayaP
Helper 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.

     

amitchandak's avatar
amitchandak
Super User
4 years ago

AtchayaP , Create two common table

 

Employee = distinct(union(distinct(Table1[Employee name]),distinct(Table2[Employee name]),distinct(Table3[Employee name])))

 

 

Development items= distinct(union(distinct(Table1[Development items]),distinct(Table2[Development items])))

 

Join the First one with all three tables and the second with Tables 1and 2, Now use measures from tables 1 and 3 with common dimension

 

refer: https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda

AtchayaP's avatar
AtchayaP
Helper 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.