Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Mapping between four table

Hi, I have four type of tables and I must map them to get count result for reporting but I have issues about it. Please help me on solving this problem. First I want to show you my minimal design this columns needed for mapping

 

My employee table

idname

position_id

1Nabi

1

2John

2

3Jack

1

 

My position table

idname
1Software Developer
2Data analyst

 

My training table

idname
1Power bi
2SQL
3C#

 

My pos_tra_mapping table. This is how I managed training for position like(man - for mandatory, asap - for As soon as possible, pref - for Preffered trainings)

 

idposition_idtraining_idtype
111man
212pref
313asap
422asap

 

And finally my emp_tra_mapping. Is employee passed this trainings or not. At the end I must create matrix for trainings will show after this table how my report must look like.

idemp_idtraining_idtraining_date
1112020-06-01
212null
3132019-06-01
4222020-06-01
531null
632null
7332019-06-01

 

Now lets look at my final report. Must train gets from emp_tra_mapping where his position in pos_tra_mapping for selected training is "man". Mandatory already trained gets count from emp_tra_mapping where not null and where his position in pos_tra_mapping for selected training is "man". pref and asap also as an mandatory

CoursesPower biSQLC#
Mandatory must train200
Mandatory already trained100
ASAP must train012
ASAP already trained012
Pref must train020
Pref already trained000

 

Hope you understand me what I want 😞

4 REPLIES 4
Anonymous
Not applicable

Screenshot_6.png

 

This is the excell form, and what I wnt from my power bi to create this kind of table. Im having issues of percentage in rows

Pragati11
Super User
Super User

Hi @Anonymous ,

 

Just want to check if you have got any relationships between these tables set-up in Power BI?

If yes, can you share screenshot on the data model please?

 

Thanks,

Pragati

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

Screenshot_5.png

 

Yes sure this is my data model, I already merged tables and already done with this but I need help on modeling report like my excell file.

Based on your business logic follow the filter direction arrows in your data model and see if they allow you to apply the desired filters.  Adjust the direction as needed.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors