Forum Discussion

dombarg's avatar
dombarg
Helper II
8 years ago

how to create virtual relation with DAX

hello.i have two tables for which i want to make relation based on their similar ID column.for example please have a look at folloing picture:

 

 

how is it possible to create relation in both direction with DAX? Am I to summarize left table with some expersion and then relate it with ID column?or something like this?

thanks for your attention.

Need Help

6 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    8 years ago

    dombarg

     

    Hi, You can use TREATAS.

     

    AmountOFTable2RR =
CALCULATE (
    SUM ( Table2[Amount] ),
    TREATAS ( VALUES ( Table1[ID] ), Table2[ID] )
)

    Regards

     

    Victor

    • dombarg's avatar
      dombarg
      Helper II
      8 years ago

      thank u very much.seems be amazing.

      what if we first : "summarize left table by accont equal to 112" and then relate their relevant ID to right table?

  • ChrisMendoza's avatar
    ChrisMendoza
    Resident Rockstar
    8 years ago

    dombarg,

     

    Will this work for you?

    NEWTable = 
DISTINCT(
    UNION ( 
        DISTINCT ( Table1[id] ),
        DISTINCT ( Table2[id] )
    )
)

    • dombarg's avatar
      dombarg
      Helper II
      8 years ago

      thank u .but i won't to establish such relation with Bridge.