table doesnt display values

[ilcaa72]

i have the exact same measure in a barchart and in a Matrix table.. the bar chart displays the correct decimal values, the matrix displays all zeros... not sure why or how to correctly fix this... the measure is formatted under Moedling tab as decimal and 4 units.

[v-danhe-msft]

Hi @ilcaa72,

Based on my test, it could work on my side:

Could you please offer me your data strcture and your measure formula?

You can also download the PBIX file to have a view.

https://www.dropbox.com/s/npw2h2mxe0t93yx/table%20doesnt%20display%20values.pbix?dl=0

Regards,

Daniel He

[ilcaa72]

hi Daniel, You didnt subtract the values in your exaple workbook.  all you did was list the values...  here is a sample work book

https://1drv.ms/u/s!Av69y58QJYzRjyE4igUTbHkFchba

i need to subtract each value from the previous month for each bank

[ilcaa72 · Accepted solution]

thanks for thr reply, here is the measure. It works fine in chart type, BUT in the Matrix. the values are all zeros.

i am just taking the current value and subtracting it from previous months value.  if the month is the 1st month, just show a zero.  Is this proper?

Match Rate Diff = 
VAR Minimun_Date = CALCULATE(MIN(MatchRate[Date]), ALL(MatchRate[Date])) 
VAR Date_to_Compare = MIN(MatchRate[Date])
RETURN

IF( Minimun_Date = Date_to_Compare, 0,
SUMX(MatchRate, MatchRate[MatchedRate]) 
- 
CALCULATE( SUMX(MatchRate, MatchRate[MatchedRate]), 
			DATEADD(MatchRate[Date],-1, MONTH )))