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

Hello Pillsbury33 

In your model a Table 2 can filter Table 1 (it flows from the 1 to the many or downhill) but the other way doesn't work.  If you right click on your join you can open the properties you can set the filter direction to BOTH then table 1 can filter table 2.

 

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

    Hello jdbuchanan71 

     

    Thanks for the speedy response. I had the relationship as 'Both" earlier but it made the Tile disappear i.e. turn gray with a cross. I have just done as suggested and this happened again. Here's the latest formula I have used:

     Ignore the errors, it does work (I have changed the names to match the earlier comments). These were from the same table. When I change ZP[FTE PER SITE] to Table 2[FTE PER SITE] the tile works again, but with the same problem that it only correctly shows the right calculation if no slice is selected.

     

    Thanks, Pillsbury33

     

     

    • jdbuchanan71's avatar
      jdbuchanan71
      Icon for Super User rankSuper User
      6 years ago

      Pillsbury33 

      Are [ZPs YTD] and [FTE PER SITE] measures or columns?

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

        Measures. I tried Columns but got the same result.