Relations between three tables and a calculation measure  [Solved]

Anything related to PowerPivot and DAX Formuale
stasinek
Posts: 2
Joined: Thu Feb 07, 2019 5:34 pm

Relations between three tables and a calculation measure

Postby stasinek » Sun Apr 07, 2019 10:41 pm

Hello,
I am asking for help in creating a measure that will calculate sales per bed in the province. I created relations between the tables, but I do not know if it should look like this.
Regards
Attachments
Sales.xlsx
(434.9 KiB) Downloaded 13 times

PhilC
Posts: 262
Joined: Tue Sep 09, 2014 8:13 am

Re: Relations between three tables and a calculation measure

Postby PhilC » Thu Apr 11, 2019 11:22 am

Hi stasinek,

One question - why were you using the CustomerProvince field in the table, is there a specific reason? It is not linked to the Beds table, so will not return the correct result for the # beds for the province.

If you use the Province from the Beds table, you can obtain the result you are looking for.

Cheers
Phil
Attachments
Sales PPF.xlsx
(450.54 KiB) Downloaded 13 times

stasinek
Posts: 2
Joined: Thu Feb 07, 2019 5:34 pm

Re: Relations between three tables and a calculation measure  [Solved]

Postby stasinek » Thu Apr 11, 2019 5:55 pm

Thanks a lot,
I meant this solution. Perfect !!!
Regards


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 1 guest