Forum Discussion

rlansing's avatar
rlansing
Resolver I
11 years ago
Solved

DAX: Running Total in Pivot Table (Works until filtered)

Hello, This is my first time asking a question. I am trying to model my data, which is approximately 7 million rows of product movement data. Included in the dataset are references to Shipment Date,...
  • Sean's avatar
    Sean
    11 years ago

    I've always had this issue with my Running Total formula - works only when there are NO other filters

     

    I should say - after you've set up the report - you can't apply additional filters 

     

    I've solved this by creating a separate tab for the Running Totals reports where no filters/slicers exist that let you modify the data.

     

    We should be lucky enough that Marco Russo sees this post and answers us (I use the formula from his book)

     

    How many tables do you have in your data model?

     

    I bet your filter comes from a different table than where the measure is - because sometimes if the filter is from the same table the formula works fine? So when you apply the filter from a different table it doesn't filter the table with the measure the way you want it too and consequently produces the wrong result.