Chapter 18 Multiple Fact Tables

This is a dedicated forum for people that have questions about the book Supercharge Power BI. In the event of errors in the book, the error information will be in this forum.
DJBrennan
Posts: 7
Joined: Thu Aug 03, 2017 7:11 pm

Chapter 18 Multiple Fact Tables

Postby DJBrennan » Sun Nov 08, 2020 7:37 pm

Hi again,
On pages 251 and 252, the model view shows a relationship between Sales and BudgetPeriod but this is not referenced in the text and I cannot see how to relate these two tables. However, a relationship is needed as I'm getting the Category total for each period rather than that period's sub total.
Many thanks,
Denis

DJBrennan
Posts: 7
Joined: Thu Aug 03, 2017 7:11 pm

Re: Chapter 18 Multiple Fact Tables

Postby DJBrennan » Mon Nov 09, 2020 5:04 pm

I created a new Column "Period" - Period = (left(Sales[OrderDateKey,6) - in Sales table and used this to relate the two tables. That fixed the problem. Is this a correct solution?
Thanks in advance
Denis

RamanaV
Posts: 65
Joined: Thu Oct 19, 2017 12:57 pm

Re: Chapter 18 Multiple Fact Tables

Postby RamanaV » Mon Nov 09, 2020 5:36 pm

The purpose of the example is how to report based on 2 data (fact) tables. We need to have common lookup tables for both fact tables in order to create such a report.
The BudgetPeriod (Lookup) table is connected to Budget table
The BudgetPeriod table is connected to Calendar table which in turn is connected to Sales table (this is called Snow flake schema)
The values will then be correct
Ramana Varanasi
Training and Office Manager
Excelerator BI Pty. Ltd.

DJBrennan
Posts: 7
Joined: Thu Aug 03, 2017 7:11 pm

Re: Chapter 18 Multiple Fact Tables

Postby DJBrennan » Mon Nov 09, 2020 9:31 pm

Sorry but this relationship (as you describe it) doesn't work but my direct relationship between BudgetPeriod and Sales does work (and this what is illustrated in the model views in the book

MattAllington
Posts: 1144
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Chapter 18 Multiple Fact Tables

Postby MattAllington » Tue Nov 10, 2020 6:29 am

Hi Denis

I will help sort this out. Please contact me via https://exceleratorbi.com.au/contact/ and include your email address so I can contact you
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

MattAllington
Posts: 1144
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Chapter 18 Multiple Fact Tables

Postby MattAllington » Thu Nov 12, 2020 8:02 am

I assume you are are talking about this image.
temp.png
temp.png (15.55 KiB) Viewed 298 times


The relationship is not to the sales table, it is to the Calendar table.

Does this fix it?
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

DJBrennan
Posts: 7
Joined: Thu Aug 03, 2017 7:11 pm

Re: Chapter 18 Multiple Fact Tables

Postby DJBrennan » Fri Nov 13, 2020 4:44 pm

Matt has kindly emailed me directly and provided a solution. This is his preferred approach.
You can turn on bi-directional filtering between BudgetPeriod and Calendar, and then hide the BudgetPeriod table and use the Calendar table Period. I think this is the best solution.
Many thanks
Denis


Return to “Help with the Book "Supercharge Power BI"”

Who is online

Users browsing this forum: No registered users and 2 guests

cron