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...
Need Help
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?

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      8 years ago

      dombarg

       

      This will be work using a Filter.

       

      Regards

       

      Victor

      • dombarg's avatar
        dombarg
        Helper II
        8 years ago

        Vvelardethank u .you know what the problem is?i want to calculate a ratio in which account number 112 in left table shoud be divided to account 8520 ( in right table ) which is not uniqe.can i do that with your solution?