Forum Discussion

FrankienessMH's avatar
FrankienessMH
New Member
3 years ago

DAX

I'm new to using DAX and Power BI and I need help with my problem. I'm using the DAX below for validation:  IF(ISBLANK(LOOKUPVALUE('Completed Visits'[ID],'Completed Visits'[ID],'Account Query'[ID_...
FrankienessMH's avatar
FrankienessMH
New Member
3 years ago

Not necessarily and I can't remove it because I need that status for another visual. status 2 are pending complete for reference. 


  • tamerj1's avatar
    tamerj1
    Community Champion
    3 years ago

    FrankienessMH 

    Please try

    Status =
    IF (
    ISEMPTY (
    FILTER (
    CALCULATETABLE (
    VALUES ( 'Completed Visits'[ID] ),
    'Completed Visits'[Status] <> 2
    ),
    'Completed Visits'[ID] = 'Account Query'[ID__c]
    )
    ),
    "NO",
    "VISIT COMPLETE"
    )