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.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper 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
    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.