Using lookupvalue for hierarchy filter

Hello,

I'm using the following column formula to return my hiearchy filter

CHANNEL NAME = lookupvalue('Hierarchy Table'[CHANNEL],'Hierarchy Table'[ID],'B.Opportunity'[ID__C])

It works, but what i'm trying to include within the formula is if it returns any blanks, to name those blanks "XYZ" (example)

I'm thinking i have to wrap it around an IF(ISBLANK), but i'm not having any luck with it. Is this possible to do?

Thank you

Ashish_Mathur
3 years ago
Hi,

Try this

=if(isblank(lookupvalue('Hierarchy Table'[CHANNEL],'Hierarchy Table'[ID],'B.Opportunity'[ID__C])),"XYZ",lookupvalue('Hierarchy Table'[CHANNEL],'Hierarchy Table'[ID],'B.Opportunity'[ID__C]))

Hope this helps.
Antonio195754
3 years ago
Figured out how to tackle this one. I just filtered the given outcome i needed to see with a measure, and date a date difference of greater than 0 and put it in a scorecard. Thanks for the help! Ashish_Mathur

Forum Discussion