Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Update Claim Status with if function and lookupvalue function

I have 2 reports; one is our incident log; and one if our claims List report. Incident log covers all incidents and claims list report only cover the incidents we claim through insurance company. I w...
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

Please update the formula of measure [Claim Status Measure] as below and check if that can return the expected result...

 

Claim Status Measure =
VAR CurrentQBE = 'Incident Register'[QBE No.]
VAR LookupResult = LOOKUPVALUE('Claims List'[Claim Status],'Claims List'[Broker Ref], CurrentQBE)
VAR AtFaultStatus = SWITCH('Incident Register'[At Fault (Y/N/Unsure)], "Y", "Fault", "N", "No Fault", "U", "Open", BLANK(), "Open")
RETURN
IF(
    ISBLANK(CurrentQBE),
    AtFaultStatus,
    IF(
        ISBLANK(LookupResult),
        "QBE No Not Match",
        LookupResult
    )
)

 

Best Regards

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Anonymous 

 

Thanks for help but i show error as "A table of multiple values was supplied where a single value was expected."