Forum Discussion

Antonio195754's avatar
Antonio195754
Icon for Helper IV rankHelper IV
3 years ago
Solved

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...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    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's avatar
    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 

Antonio195754's avatar
Antonio195754
Icon for Helper IV rankHelper IV
3 years ago

Hi Ashish_Mathur I added another tab with the desired outcome.  I'm wanting to show these days difference average in scorecards within PBI with their respective headers.  Below is the screenshot of the new tab i created.

 

 

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

I do not see a second tab in that workbook.  In that new tab, please also explain how you got the result.