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__c])),"NO","VISIT COMPLETE")

at the same time, i only want the lookup to look at everything at this column except the value "2". 

'Completed Visits'[Status] <> 2

Thanks in advance!

3 Replies

  • 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"
      )