Forum Discussion

viniciusfigueir's avatar
viniciusfigueir
Frequent Visitor
6 years ago
Solved

Running Total with Slicer

I'd like to create a running total where I can filter the rows used by using a date slicer on another column. I have one data table with two columns, 'time' and 'dat', that looks like this: table_a ...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi viniciusfigueir 

    First, you should know that:

    1. Calculation column/table not support dynamic changed based on filter or slicer.
    2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

    https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

    Second, Try these two measure that based on your column formula

    Count maeasure = CALCULATE(COUNTROWS(table_a), FILTER(ALLSELECTED(table_a), table_a[time] <= MAX(table_b[Value])))
    relative measure = [Count maeasure]/CALCULATE(MAXX(table_b,[Count maeasure]),ALLSELECTED(table_b))

     

    Regards,

    Lin

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

You will need to use a measure then, not a column. Columns can't be dynamic like that.

  • viniciusfigueir's avatar
    viniciusfigueir
    Frequent Visitor
    6 years ago

    How would I do that using a measure? thanks in advance

    • v-lili6-msft's avatar
      v-lili6-msft
      Community Support
      6 years ago

      hi viniciusfigueir 

      First, you should know that:

      1. Calculation column/table not support dynamic changed based on filter or slicer.
      2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.

      https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

      Second, Try these two measure that based on your column formula

      Count maeasure = CALCULATE(COUNTROWS(table_a), FILTER(ALLSELECTED(table_a), table_a[time] <= MAX(table_b[Value])))
      relative measure = [Count maeasure]/CALCULATE(MAXX(table_b,[Count maeasure]),ALLSELECTED(table_b))

       

      Regards,

      Lin