Forum Discussion

kevinbrad06's avatar
kevinbrad06
Frequent Visitor
4 years ago

Rolling Totals

I've tried searching everywhere for this but I haven't found a result that helps yet. I'm trying to get running totals of values but I believe the fact I'm looking across multiple tables is breaking the total. It works fine when only including the columns from [items] but as soon as I the [quad_1] column it no longer creates the totals over the entire item. I can't add the quad column to the "FILTER(ALL())" because it isn't in the same table as the item columns. Any other way to do this that doesn't require redesigning how I'm bringing the data into the report?

 

 

 

 

 

DAX
Running Totals

2 Replies

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    Hi kevinbrad06 

     

    Try to add REMOVEFILTER(quads[quad_1]) to the calculate formula after the filter and see the result.

     

    If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

    Appreciate your Kudos!!

     

    • kevinbrad06's avatar
      kevinbrad06
      Frequent Visitor
      4 years ago

      I tried it before and after the filter statement and it still didn't give the desired result. The desired result would be the table on the left but havin the quad_1 column included in the table as well.