Help needed to get the relationship and the overall output

[ashmitp869]

Hi,

My dataset is Data where each employee has activity and tickets.

The Activity,Ticket Dimension is not similar to the Fact table. So unable to join.

Help me to find the relationship -
Activity                                                    Data
Excavator / kanga operation                    VOC 0010K Excavator Operations (VOC_0010)


Ticket                                                      Data
First Aid                                             First Aid Training

Data Model

Report Sample

Role -> Many Actvities
Actvity -> Many Tickets

Operator will be Green when it has all the activity and ticket fulfillment.

Sample file - https://github.com/suvechha/samplepbi

[v-hashadapu]

Hi @ashmitp869 , Hope you're doing fine. Can you confirm if the problem is solved or still persists? Sharing your details will help others in the community.

[v-hashadapu]

Hi @ashmitp869 , Thank you for reaching out to the Microsoft Community Forum.

We find the answer shared by @amitchandak  is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.
Thank you @amitchandak  for your valuable response.

[v-hashadapu]

Hi @ashmitp869 , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

[amitchandak]

@ashmitp869 , You can make "Role Vs Activity" and "Role" join bi-directional .

For Ticket you need have some common column with fact of other dimensions