Forum Discussion

sree2604's avatar
sree2604
Regular Visitor
1 year ago
Solved

Need Help with Data Model / DAX

I am working on making a dataset more user friendly / light in size. Data Model along with DAX look very promising and would greatly appreciate any help to achieve the below.     Problem:  I need t...
  • sanalytics's avatar
    sanalytics
    1 year ago

    sree2604 
    Please create proper data model rather than only create DAX.. beacuse DAX works on relationship.. Your two tables have different grain so you should have two fact table.. Below is the complete screenshot of your data model

    You need to have a simple star schema

     

    Complete pbix file is attached below.

     

    Hope it helps

    Regards

    sanalytics

     

     

     

     

sanalytics's avatar
sanalytics
Super User
1 year ago

sree2604 
Please create proper data model rather than only create DAX.. beacuse DAX works on relationship.. Your two tables have different grain so you should have two fact table.. Below is the complete screenshot of your data model

You need to have a simple star schema

 

Complete pbix file is attached below.

 

Hope it helps

Regards

sanalytics

 

 

 

 

sree2604's avatar
sree2604
Regular Visitor
1 year ago

worked like a magic!  thank you so much 🙂
appreciate you for sharing the file with the solution, mapping the tables back in the data model and clearly showing how to create the relationships to solve this.