Forum Discussion

JohannesM's avatar
JohannesM
Icon for Helper I rankHelper I
3 years ago

Getting the column sum when multiplying with another table.

Hi,   I have two tables and I'm using DAX to multiply a column from table1 with a column from table2. The two tables are connected by a key so it is multiplying per row (the key is built on Group a...
Need Help
  • JohannesM's avatar
    JohannesM
    Icon for Helper I rankHelper I
    3 years ago

    Hi FreemanZ 
    But isn't that what I already do with the relation in PBIs "Model"-page?  RowID in the picture below is based on Group and Year to get that unique match. 

     

  • JohannesM's avatar
    JohannesM
    Icon for Helper I rankHelper I
    3 years ago

    Actually the problem I have is that not both columns can have an unique match since it's one-to-many. But I'm sure that the multiplying is possible. It is in the column with unique match that I want to get the row instead of column when multiplying.