Forum Discussion
firstnonblank issue
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
Hi Anonymous ,
Try to delete relationship between INC_PROD table and calendar table, then change the Cross filter direction of all relationships from "Single" to "Both". This means for filtering purposes, these tables are treated as if they're a single table.
Best Regards,
Amy
Hi v-xicai ,
I can not disable the relationship because I have enough measures that are dependent on this relationship.
Is there no other way to do this without having to disable the relationship between tables?
Best Regards,
JO
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
Hi v-xicai ,
It work. Thank you very much and thanks for the explanation :smileyhappy:
Best Regards,
JO