Relations between three tables and a calculation measure

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 3 times

PhilC
Posts: 219
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 2 times

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

Re: Relations between three tables and a calculation measure

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 2 guests

cron