Forum Discussion

timward10's avatar
timward10
Helper II
1 year ago
Solved

Filter help

Hi,    I have a report with multiple tables on it, everything is working currently until I select the below field as a filter and it just doesn't populate with any account names.    I have added ...
Need Help
  • Elena_Kalina's avatar
    Elena_Kalina
    1 year ago

    Hi timward10 

    Try this one:

    Account Name from Demand Gen =
VAR UltimateParentCode = SELECTEDVALUE(event[Ultimate Parent IFS Code])
VAR UltimateParentCodeAsText = CONVERT(UltimateParentCode, STRING)  // Convert integer to text
VAR MatchedAccount = 
    LOOKUPVALUE(
        'Demand Gen Target List'['Demand Gen Account Name'],
        'Demand Gen Target List'[InvoiceCustomerNumber], UltimateParentCodeAsText,  // Now comparing text-to-text
        BLANK()
    )
RETURN
    IF(ISBLANK(MatchedAccount), "Not Found", MatchedAccount)

     

    If this post helps, then please  don't forget to give a "Kudos" – I’d truly appreciate it! 

    Thank you.

v-kathullac's avatar
v-kathullac
Community Support
1 year ago

Hi timward10 ,

Thank you for reaching out to Microsoft Fabric Community Forum.

can you try the below dax measure

 

Account Name from Demand Gen =
VAR UltimateParentCode = VALUE(SELECTEDVALUE(event[Ultimate Parent IDS Code]))
VAR MatchCheckCount =
LOOKUPVALUE(
'Demand Gen Target List'[Demand Gen Account Name],
'Demand Gen Target List'[InvoiceCustomerNumberPM], UltimateParentCode,
BLANK()
)
RETURN
IF(ISBLANK(MatchCheckCount), "Not Found", MatchCheckCount)

 

Regards,

Chaithanya.