Measure total issue in KPI showing as 0

[Gangasaniravi]

Hello,

i am facing a issue with measure total in KPI i am getting 0 instead of -2, Please find below data.

Month-Year	FTE	Net Movement (FTE)
Jan-21	76.25
Feb-21	76.25	0
Mar-21	75.75	-0.5
Apr-21	75.75	0
May-21	76	0.25
Jun-21	75.75	-0.25
Jul-21	74.75	-1
Aug-21	74.75	0
Sep-21	74.75	0
Oct-21	74.25	-0.5
Nov-21	74.25	0
Dec-21	74.25	0
	Total	-2

Below is the calculation for  Net Movement below

Headcount_Previous= CALCULATE ( sum(headcount) ,

DATEADD ([Date], -1, MONTH))

Net Movement = IF ( sum(headcount)

  && [Headcount_Previous],

sum(headcount) -[Headcount_Previous] ) 

Data matching in Table but in KPI i am getting 0, Please hepl me on this.

Regards,

Ravi

[v-rongtiep-msft · Accepted solution]

Hi @Gangasaniravi ,

This seems to be caused by an incorrect measure total. 

You can also create a measure based on [Net Movement].

result=
var _b = SUMMARIZE('table','table'[date],"aaa",'table'[Net Movement])
return
IF(HASONEVALUE('table'[date]),[Net Movement],SUMX(_b,[aaa]))

 Or you can refer to my pbix file.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.