Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Relationship between tables

Hi Power BI Super Community,   I am unable to establish a relationship between my tables. I have tried using a star schema. A fact table and the dim tables.   However, the star schema does not wo...
Need Help
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    i just download the file which you shared with me on Satuday and the calculated formula which i suggested to you is already there.  I downloaded and opened that file - everything is just fine and there are no filters on the scatter plot visual.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

I still do not understand what you want but from whatever i can see if this is any helpful.  Bring over the hours from the Tutorial log_long table to the CA table with this calculated column formula

Column = CALCULATE(SUM('Tutorial Log_Long'[Total Hours]),FILTER('Tutorial Log_Long','Tutorial Log_Long'[Student ID]=EARLIER('CA #1_Long'[Student ID])))

To your scatter plot visual, drag this column to the X-axis.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Ashish_Mathur ,

 

Thank you for the formula. It works. 

 

 

 

However, my original suspicion was that my relationships were set up incorrectly. Tutorial Log_Long, CA#1_Long, Tutor Hours by Session are connected to Teacher-Student List (Fact Table). Teacher-Student List has unduplicated student ids.

 

 

My initial thought was that by connecting all three tables to my fact table, that i would be able to create slicers for Sessions Weeks (groups) to control both graphs.

 

When i use your DAX for column, i get the following filter that i cannot remove. Total Tutor Hours is 3.0. I want all Total Tutor Hours to be used.

 

 

Tutoring Only_V2.pbix

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    I did not apply any filter in the file that i shared with you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Ashish_Mathur ,

       

      Thank you for your reply. Could you link or upload your PBIX?

       

      I want to check my PBIX against your PBIX.

       

      Thank you.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        3 years ago

        Hi,

        i just download the file which you shared with me on Satuday and the calculated formula which i suggested to you is already there.  I downloaded and opened that file - everything is just fine and there are no filters on the scatter plot visual.