cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Sachy123 Regular Visitor
Regular Visitor

Best way to model 2 fact and 1 dimensions

I am trying to generate a report wherein I need to get the following view 

The Date Filter is the Date Dimension

 

Reportneeded.pngHere is what the model looks like.. but without relationships.

 

ProductDimension.png

 

How can I relate the tables, such that the report then filters out the other measures like Delivery Costs and Order Qty for the selected Date from the date dimension?

 

Any help would be appreciated.. I am also trying here.

Cheers

Sachy

1 ACCEPTED SOLUTION

Accepted Solutions
sokg Established Member
Established Member

Re: Best way to model 2 fact and 1 dimensions

@Sachy123 

 

Please try this

 

Capture1.JPG

 

What is DlvID in your FactCosts Table???

2 REPLIES 2
Super User
Super User

Re: Best way to model 2 fact and 1 dimensions

@Sachy123 

Can you share your .pbix file?  You can upload it to OneDrive or DropBox and post the link here.

sokg Established Member
Established Member

Re: Best way to model 2 fact and 1 dimensions

@Sachy123 

 

Please try this

 

Capture1.JPG

 

What is DlvID in your FactCosts Table???

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 54 members 1,102 guests
Please welcome our newest community members: