Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

firstnonblank issue

Hello,    Sorry for the question, I know it's a bit basic, but I'm a bit blocked...   i have this measure :   CALCULATE ( FIRSTNONBLANK ( INC[U_END], 1 ), FILTER ( 'INC', ...
Need Help
  • v-xicai's avatar
    v-xicai
    7 years ago

    Hi Anonymous ,

     

    If there are Unique IDs for [PROBLEM_ID] or [NUMBER_ID], this error message will be thrown. So the LOOKUPVALUE function is not suitable for this scenario. While the FIRSTNONBLANK function in the scenario which is equivalent to the LOOKUPVALUE will be Ok. If you need to show the blank value, you can create column but not a measure using the DAX below.

     

    Column 1= CALCULATE ( FIRSTNONBLANK ( 'INC_PROD'[CAUSED_BY], 1 ), FILTER ( 'INC_PROD', 'INC_PROD'[PROBLEM_ID]= 'PROB_PROD'[NUMBER_ID]))

     

    Best Regards,

    Amy

v-xicai's avatar
v-xicai
Community Support
7 years ago

Hi Anonymous ,

 

If there are Unique IDs for [PROBLEM_ID] or [NUMBER_ID], this error message will be thrown. So the LOOKUPVALUE function is not suitable for this scenario. While the FIRSTNONBLANK function in the scenario which is equivalent to the LOOKUPVALUE will be Ok. If you need to show the blank value, you can create column but not a measure using the DAX below.

 

Column 1= CALCULATE ( FIRSTNONBLANK ( 'INC_PROD'[CAUSED_BY], 1 ), FILTER ( 'INC_PROD', 'INC_PROD'[PROBLEM_ID]= 'PROB_PROD'[NUMBER_ID]))

 

Best Regards,

Amy

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi v-xicai ,

 

It work. Thank you very much and thanks for the explanation :smileyhappy:

 

Best Regards, 

JO