Forum Discussion

abelrmg's avatar
abelrmg
Helper II
6 years ago
Solved

Relationship between tables

Hello,

 

I have 4 four tables:

1. Invoicing

2. Date table

3. Accounts receivable

4. Attribute

 

This is the relation:

 

The visualization is this:

The formula Ventas-1 doesn't work when i select a filter for department (LN01,LN02).

 

The formula is:

Ventas-1 = CALCULATE([Ventas]|PARALLELPERIOD(Dates[Date]|-1|month))
 
Ventas = SUM(RMG_AXFACTCUSTINVOICING[LINEAMOUNTMST])
 
The result is this:
 
Don't show info for Ventas-1 in all months only when the other table have a data. But if a disable the relationship betwen Departamento table with the other transaciont tables works fine.
 
Any ideas how can I do this arrangement?
 
Regards
Need Help
  • abelrmg's avatar
    abelrmg
    6 years ago

    Hello, thanks to everyone the error is this relationship:

     

     

    I configured it as a single way and works fine.

     

    Regards

     

     

6 Replies

  • abelrmg's avatar
    abelrmg
    Helper II
    6 years ago

    Hello, thanks to everyone the error is this relationship:

     

     

    I configured it as a single way and works fine.

     

    Regards

     

     

  • aj1973's avatar
    aj1973
    Community Champion
    6 years ago

    abelrmg 

    try to make the relationship between tables go both way for all of them and see how it works out!

    • abelrmg's avatar
      abelrmg
      Helper II
      6 years ago

      aj1973 , does not allow me to configure relationships in both way it sends an ambiguity error and i should delete a relationship

       

      Regards

    • abelrmg's avatar
      abelrmg
      Helper II
      6 years ago

      amitchandak , when I apply the filter for table Departamento usign the forumula  that you proposed to me the visual mark error: the DATEADD function expects continuous selection....

      Regards