Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

FirstNonBlank

Here's a firstnonblank() question again.    This was probably answered before however I cannot find the rigth answer in all the power bi blog.    I have three tables structured this way.    Pro...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous 

    You may need to change the cross filter direction from "Single" to "Both" between Definition table to product definition, then your formula may work well

     

    Best Regards,

    Lin

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous 

I am guessing a bit, as you havent provided any sample data.

Try using LOOKUPVALUE() function. Something like:

LOOKUPVALUE(
Firstnonblank(Definition table[definition_description),0),
Definition table[product_id], Product Table[product_id])

OR use the relevant IDs from relevant tables.

 

Thanks!
A