Forum Discussion

ericsara's avatar
ericsara
Icon for Helper I rankHelper I
4 years ago
Solved

Find a single value in a table based on multiple criteria

I have tables with columns as follows; Tickets Ticket Number Ticket Name Client ID Status ID Type ID Client Client ID Name Address Status Status ID Name  Description Type Type ...
Need Help
  • ericsara's avatar
    ericsara
    4 years ago

    Ended up using this DAX

     

    CALCULATE ( FIRSTNONBLANK('Tickets'[Ticket Number],1),'Status'[StatusID]="Open",'Type'[TypeID]="Client Management",'Client'[ClientID]=ClientID)
     
    Where ClientID is a lookup for the selected (using a slicer) client ID. 
ericsara's avatar
ericsara
Icon for Helper I rankHelper I
4 years ago

Ended up using this DAX

 

CALCULATE ( FIRSTNONBLANK('Tickets'[Ticket Number],1),'Status'[StatusID]="Open",'Type'[TypeID]="Client Management",'Client'[ClientID]=ClientID)
 
Where ClientID is a lookup for the selected (using a slicer) client ID.