Forum Discussion

PriscillaCamp's avatar
PriscillaCamp
Advocate IV
6 years ago
Solved

DAX

Hi, I am trying to create a backlog column for my monthly volume of tickets. I have an open measure and a closed measure. Their formulas to create these measures are:   Opened = CALCULATE(COUNT(Vol...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi PriscillaCamp 

     

    Please kindly check whether you'd like to get below results: (It's will be much helpful if you can attach the copyable table next time)

    1.  Insert an index column in power query to keep the data sequence 

    2. Use below measure:

    Measure 2 = SUMX(FILTER(ALL(TableA),[Index]<=MAX(TableA[Index])),[Remaining])

     

    Note there're miscalculation in your previous capture.

     

     

v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi PriscillaCamp 

 

Please kindly check whether you'd like to get below results: (It's will be much helpful if you can attach the copyable table next time)

1.  Insert an index column in power query to keep the data sequence 

2. Use below measure:

Measure 2 = SUMX(FILTER(ALL(TableA),[Index]<=MAX(TableA[Index])),[Remaining])

 

Note there're miscalculation in your previous capture.