Forum Discussion

united2win's avatar
united2win
Helper III
5 years ago

DAX Calculation (Running Total / Total ) - Help needed!

Hi, 

Context:

I have three tables below: 

Table 1: Is a simple count per batch number over the x axis (0,1,2,3,4 etc.)

Table 2: Is the running total

Table 3: Is the total per batch number

 

* EDIT: The running total's do not match table 3 because I have filtered out blanks

 

 

I would like to create a measure that will divide the running total by the total per batch. So I can create a table that will look like this:

 

Batch Number0123
10-20200.190.24  
11-20200.06   

 

Any suggestions?

1 Reply

  • negi007's avatar
    negi007
    Community Champion

    united2win Can you share your data in a text format or your powerbi file so that we could create calculation at our end.