Replace (Blank) with 'Value' - Calculated Column

[Anonymous]

Hi Team,

I have a calculated column in my table view as below :

Sample= Table[A] & " " & LOOKUPVALUE('Table1'[B],'Table1'[C],Table[A],Blank())

which returns the below 

Please advise since I tried using ISBLANK but nothing seems to work

[Anonymous]

Hi @Anonymous 

Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.

Best Regards,

Jayleny

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

[Anonymous]

@V-V @Anonymous Please refer to the attached!

Can the category for both these entries be changes to "New Test"?

Dokumente

Thanks

[Anonymous]

Hi @Anonymous 

Can you elaborate on the circumstances under which the value of the “Category New” column changes to “New Test”?

Best Regards,

Jayleny

[Anonymous]

@Anonymous  When there is no value or maybe we can say if the value "1005" or "1006" is noticed then I would like to call it "New Test". Thanks

[Anonymous]

Hi @Anonymous 

Please try the following Dax:

Measure = IF(SELECTEDVALUE('Actuals'[Category])=BLANK(),"New Test",MAX('Actuals'[Category]))

Best Regards,

Jayleny

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

[Anonymous]

@Anonymous Thanks...can you please tell me if this can be shown as a column as my data needs this to be shown as  a dimension instead of a measure.

[Anonymous]

Hi @Anonymous 

Try the following DAX:

Column = IF([Category]=BLANK(),"NA",[Category])

Best Regards,

Jayleny

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

[Anonymous]

@Anonymous  When I try this I again get back to the original issue where only blank is shown and no value is updated. Please advise!

[Anonymous]

Hi @Anonymous 

I did the corresponding operation in the PBIX file you provided, please refer to the DAX in it.

Best Regards,

Jayleny

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

[Anonymous]

@Anonymous Thanks works perfectly fine in the sample file but not in the real scenario..could you please advise why? I see only blanks again unforunately. Would the below be reason?

This is actually the calculated field calculation for Category

LOOKUPVALUE(Table[A] & " " & LOOKUPVALUE('Table1'[B],'Table1'[C],Table[A],Blank()))

[Anonymous]

@Anonymous Thank you I see it is close but please refer to the below. The first 3 rows under measure column should show up as "BC"

[Anonymous]

Hi @Anonymous 

Consider using the following measure:

Measure = IF(SELECTEDVALUE('Actuals'[Category])=BLANK(),"NA",MAX('Actuals'[Category]))

Best Regards,

Jayleny

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

[Anonymous · Accepted solution]

Hi @Anonymous  Thanks. Tried same for some reason my side it does not work. Also please note that my actual calculation is a Sample= Table[A] & " " & LOOKUPVALUE('Table1'[B],'Table1'[C],Table[A],Blank()) 

[Anonymous]

Hi @Anonymous 

You're using a calculated column, please use measure to do the calculation.

Best Regards,

Jayleny

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

[Anonymous]

Try IF( ISBANK( ......) = True, "Value you want when blank", "value you want when not blank i.e. your function")

[Anonymous]

@Anonymous Thanks but no change. For some reason the blank values remain

[Anonymous]

I think the issue is within the lookup, but I'm not experienced enough to resolve it without seeing more data. Hopefully someone will come along and give you more guidance