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 paste your excel data here that I can copy it,  or preferable a pbix that I can draw it up for you.

 

PriscillaCamp's avatar
PriscillaCamp
Advocate IV
6 years ago

Hi,

 

My file is from SQL Server. I do not know how to attach a PBIX to this message. Is there a place where I put it on your one drive?

 

Thanks.

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

    Hi PriscillaCamp 

     

    1. You can upload your file to Onedrive/Dropbox, and share the link here. (Make sure the connection mode is Import, I can't view it on my side if it is in Direct query mode.

    2. Alternatively, copy the table shown in the previous table, and paste it here with table format. that I can copy it.