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.

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.