Assigning "Not Assigned" to blank values in my table without editing the dataset

[Anonymous]

Please help me, how do I assign "Not Assigned" to my blank values

This formula returns an error

Market Segment Blanks = IF(ISBLANK(SUMMARIZE(R_ESURVEY_CONSOLIDATED_V001,R_ESURVEY_CONSOLIDATED_V001[Proj: Market Segment])),"Not Assigned",SUMMARIZE(R_ESURVEY_CONSOLIDATED_V001,R_ESURVEY_CONSOLIDATED_V001[Proj: Market Segment]))

this other formula only returns 1 value

Market Segment Blanks = IF(ISBLANK(MAX(R_ESURVEY_CONSOLIDATED_V001[Proj: Market Segment])),"Not Assigned",MAX(R_ESURVEY_CONSOLIDATED_V001[Proj: Market Segment])

[v-chuncz-msft]

@Anonymous 

You'll need to add a calculated column.

Column =
IF (
    R_ESURVEY_CONSOLIDATED_V001[Proj: Market Segment] = BLANK (),
    "Not Assigned",
    R_ESURVEY_CONSOLIDATED_V001[Proj: Market Segment]
)

[Anonymous]

it works on a calculated column, but I was thinking of putting it in a measure, is it possible?

[Igotzepowerbi]

If anyone has the answer for this still. My data set is too large to be adding calculated columns really need to do it in measure if anyone has a workaround?