Forum Discussion
Power BI Matrix Report - Total Incorrect
Hello All,
I am trying to use a matrix visualization to view the count of issues created, updated and in backlog. While trying to retrieve backlog issues, PowerBI does and total of all rows instead of displaying the last value for the month. Could you please help out with this?
| Month | Created Count | Closed Count | Growth (Created-Closed) | Backlog (formula given below) |
| (+)February | 10 | 3 | 7 | current value 13 but it should be 7. |
| February 1 | 3 | 2 | 1 | 1 |
| February 3 | 5 | 1 | 4 | 5 |
| February 4 | 2 | 0 | 2 | 7 |
Calculation currently used for backlog column of the table.
" Backlog = CALCULATE(SUM('Table'[Growth]),ALL('Table'), 'Table'[Date] <= EARLIER('Table'[Date]))"
Can somebody help me how to solve this?
Thanks in advance!
Hi radhikalakshmi ,
- Method1——Change the summarization type from Sum to Max like this:
- Method2——Need an additional measure:
Measure based on Backlog column = IF(HASONEVALUE('Table'[Backlog]),MAX('Table'[Backlog]),MAXX(ALL('Table'),[Backlog]))- Method3—— Create a measure instead:
Backlog Measure instead of Backlog column = CALCULATE(SUM([Growth (Created-Closed)]),FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))Here is the final output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi radhikalakshmi ,
- Method1——Change the summarization type from Sum to Max like this:
- Method2——Need an additional measure:
Measure based on Backlog column = IF(HASONEVALUE('Table'[Backlog]),MAX('Table'[Backlog]),MAXX(ALL('Table'),[Backlog]))- Method3—— Create a measure instead:
Backlog Measure instead of Backlog column = CALCULATE(SUM([Growth (Created-Closed)]),FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date])))Here is the final output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
