Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Rolling Inner Join Sum

Hey Guys,    I'm looking to do an inner join on a uniqueID from one table to another and then take the sum of a dollar amount  from the other table.  I want to write this as a DAX measure.   So I...
General Comment
Need Help
Show and Tell
Tips and Tricks
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    You are welcome.  You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Unless we have those 2 columns in TabB, the end result will not make any sense.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Ashish_Mathur 

 

So it's not possible to be able to slice on Tab A (SalesPerson or Position) and then use the solution you had gave me in the previous post?

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

    Since those 2 columns are only in TabA, the calculations based on only that Table can be slicer by the two new columns.  The calculations on TabB and ratio will not be slicer because these 2 columns are not on TabB.

    Hope this clarifies.