display all status but complete status should include value of Approaching Expiry and Expired

[ganes]

display all status but complete status should include value of Approaching Expiry and Expired

I need complete count to be 147(complete + Approaching Expiry + Expired) How to do that

i need the result 

[Idrissshatila]

Hello @ganes ,

then you need to create a new calculated column that specifies that if the status is Approaching Expiry or Expired then complete else to give the status and use it in the chart as a field.

New status = IF(TableName[Status] in {"Approaching Expiry","Expired"},"Complete",TableName[Status])

[ganes]

Hi @Idrissshatila 

I tried that approach already but it is exluding Approaching Expiry and Expired status. I need all statuses to be displayed. 

[Idrissshatila]

@ganes ,

it's either you need them to show and their values would show with them as in you main screenshot, or you want their values to show with the completed but they won't show, you can't have both.

[ganes]

Hi @Idrissshatila thanks for responding, but could you also explain why, because i need to justify the logic also. 
or is there any workarround possible?

[Idrissshatila · Accepted solution]

Hello @ganes ,

because you need to link the numbers to a specific value either complete or the expired.