Modeling - consolidated tables

Hi Dimitris_Kats 

For better data model, please create a DIM table for Illness and connect with both Fact table
You can enter data for DIM table directly in Power BI desktop or Power Query editor
Or usa DAX =  DISTINCT(Table2[illnesscolumn]) to create the DIM table

Let me know if that works for you

If your requirement is solved, please mark THIS ANSWER as SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.

Thanks
Pijush
Linkedin