Replace (Blank) with 'Value' - Calculated Column

[GallopPBI]

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

[v-jialongy-msft]

Hi @GallopPBI 

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.

[GallopPBI]

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

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

Dokumente

Thanks

[v-jialongy-msft]

Hi @GallopPBI 

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

Best Regards,

Jayleny

[GallopPBI]

@v-jialongy-msft  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

[v-jialongy-msft]

Hi @GallopPBI 

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.

[GallopPBI]

@v-jialongy-msft 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.

[v-jialongy-msft]

Hi @GallopPBI 

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.

[GallopPBI]

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

[v-jialongy-msft]

Hi @GallopPBI 

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.

[GallopPBI]

@v-jialongy-msft 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()))

[GallopPBI]

@v-jialongy-msft 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"

[v-jialongy-msft]

Hi @GallopPBI 

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.

[GallopPBI · Accepted solution]

Hi @v-jialongy-msft  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()) 

[v-jialongy-msft]

Hi @GallopPBI 

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.

[Alex25]

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

[GallopPBI]

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

[Alex25]

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