PwerQuery is considered Incompleted Status even though Completed is used

[JeevanMallya]

ISSUE_KEY	SPRINT_REPORT_STATUS	ISSUE_TYPE_NAME	SPRINT_NAME
ABC-74676	INCOMPLETED	Task	Sprint 208
ABC-74579	COMPLETED	Story	Sprint 208
ABC-74585	COMPLETED	Story	Sprint 208
ABC-74415	COMPLETED	Task	Sprint 208
ABC-74160	COMPLETED	Task	Sprint 208
ABC-74159	COMPLETED	Task	Sprint 208
ABC-73181	COMPLETED	Story	Sprint 208
ABC-73875	COMPLETED	Story	Sprint 208

I have these columns in Sprint Master Table and i am trying to claculate Total Completed.

The query i am using is :

WORK_UNITS_COMPLETED = IF(Sprint_Master[SPRINT_REPORT_STATUS]=="COMPLETED" && Sprint_Master[ISSUE_TYPE_NAME]=="Story" || Sprint_Master[ISSUE_TYPE_NAME]=="Task", CALCULATE(Count(Sprint_Master[ISSUE_KEY])))

But some how it is considering even Incompleted ones and showing result as 8.

The result is 

ISSUE_KEY	SPRINT_REPORT_STATUS	ISSUE_TYPE_NAME	WORK_UNITS_COMPLETED
ABC-74676	INCOMPLETED	Task	1
ABC-74579	COMPLETED	Story	1
ABC-74585	COMPLETED	Story	1
ABC-74415	COMPLETED	Task	1
ABC-74160	COMPLETED	Task	1
ABC-74159	COMPLETED	Task	1
ABC-73181	COMPLETED	Story	1
ABC-73875	COMPLETED	Story	1

Help needed as why Incompleted is also considered when query is correct.

[JeevanMallya · Accepted solution]

Thank you very much

[tharunkumarRTK]

@JeevanMallya 

The code that you have given is DAX, not the m code in power query. To get you expected result, please try this code

WORK_UNITS_COMPLETED = IF(Sprint_Master[SPRINT_REPORT_STATUS]="COMPLETED" && (Sprint_Master[ISSUE_TYPE_NAME]="Story" || Sprint_Master[ISSUE_TYPE_NAME]="Task" ) , CALCULATE(Count(Sprint_Master[ISSUE_KEY])))

Need Power BI consultation, hire me on UpWork .

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun

[JeevanMallya · Accepted solution]

Thank you very much

[tharunkumarRTK · Accepted solution]

@JeevanMallya 

No problem, Please accept my answer as a solution.

Need Power BI consultation, hire me on UpWork .

If the post helps please give a thumbs up

If it solves your issue, please accept it as the solution to help the other members find it more quickly.

Tharun