Power BI Matrix Report - Total Incorrect

[radhikalakshmi]

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!

[v-eqin-msft · Accepted solution]

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.

[Greg_Deckler]

@radhikalakshmi  You need MM3TR&R: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community