Forum Discussion

Pillsbury33's avatar
Pillsbury33
Icon for Helper I rankHelper I
6 years ago

How to slice across two tables

Hello everyone,   I’ve looked at a number of threads but can’t anything to help with this. I am trying to divide two columns from different tables and create a new measure. I have tried 100 differe...
Need Help
jdbuchanan71's avatar
jdbuchanan71
Icon for Super User rankSuper User
6 years ago

When you reference a measure you don't need a table name in front of it so it should be.

ZPs/FTE = DIVIDE ( [ZPs YTD], [FTE PER SITE], 0 )

Would it be possible for you to share your .pbix?  The di-directional should have worked as far as I can tell. 

Pillsbury33's avatar
Pillsbury33
Icon for Helper I rankHelper I
6 years ago

Hello jdbuchanan71

 

My bad! I just happened to use the one example where the sites in the two tables where spelt slightly different. I changed the formula to this, but also added a new relationship between the UserSite and the FTE column (not sure if this was needed), corrected the name and 'hey presto!'.

 

Many thanks for your help!