Forum Discussion
united2win
5 years agoHelper III
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 Number | 0 | 1 | 2 | 3 |
| 10-2020 | 0.19 | 0.24 | ||
| 11-2020 | 0.06 |
Any suggestions?
1 Reply
- negi007Community Champion
united2win Can you share your data in a text format or your powerbi file so that we could create calculation at our end.