Forum Discussion

timazarj's avatar
timazarj
Icon for Helper II rankHelper II
5 years ago
Solved

Table relationships

Hi,   in my model I have a Date table, using it a slicer, Employee table, using it for usercode. there are 2 different tables for Sales and Returns. I created the relationship between the Date to S...
Need Help
  • SivaMani's avatar
    SivaMani
    5 years ago

    timazarj,

    Date(Date and Sales Table) is the culprit. Make sure that you have matching records for Date.

SivaMani's avatar
SivaMani
Icon for Resident Rockstar rankResident Rockstar
5 years ago

timazarj,

 

Is it possible to share your model diagram? Your result screenshot?

timazarj's avatar
timazarj
Icon for Helper II rankHelper II
5 years ago

 

The right side should show the sales diagram and numbers which are blank now.

  • SivaMani's avatar
    SivaMani
    Icon for Resident Rockstar rankResident Rockstar
    5 years ago

    timazarj,

    X-DAT and Upsells are calculated measures?

    • timazarj's avatar
      timazarj
      Icon for Helper II rankHelper II
      5 years ago

      yes they are.

      • SivaMani's avatar
        SivaMani
        Icon for Resident Rockstar rankResident Rockstar
        5 years ago

        timazarj,

        Date(Date and Sales Table) is the culprit. Make sure that you have matching records for Date.

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    5 years ago

    SivaMani 

    You should set up the Employee table to have a one-to-many relationships with both fact tables instead of many-to-many.

    Also, can you post the measures you are using in the visuals?

    • timazarj's avatar
      timazarj
      Icon for Helper II rankHelper II
      5 years ago
      Upsells = CALCULATE(COUNT('Sales'[ActivityCode]), FILTER('Sales','XDAT-Upsell'[ActivityCode]= "UPSE"))
      • SivaMani's avatar
        SivaMani
        Icon for Resident Rockstar rankResident Rockstar
        5 years ago

        timazarj,

         

        Is it possible to share the pbix file (without any sensitive info)?

    • timazarj's avatar
      timazarj
      Icon for Helper II rankHelper II
      5 years ago

      I did change that still not working