DAX: multi IFs.

[countryfan_nt]

Hello friends, Hope all is safe & Well!

Please help me with the DAX formula below:
no error, but the results keep showing blanks.

Your kind support is always is appreciated in advance

=SWITCH ([Item Name],
"Invoice Number" ,LOOKUPVALUE(Lookup[Lookup Value],Lookup[Lookup Value],[Invoice Number]),
  "PerformingDoctorID",LOOKUPVALUE(Lookup[Lookup Value],Lookup[Lookup Value],[PerformingDoctorID]),
   "ProcedureID",LOOKUPVALUE(Lookup[Lookup Value],Lookup[Lookup Value],[ProcedureID]),
   " PatientID ",LOOKUPVALUE(Lookup[Lookup Value],Lookup[Lookup Value],[PatientID]), "" )

 

[Matt Allington]

If you are using LOOKUPVALUE, you probably have missed something about how DAX works. I suggest you read this article. The Optimal Shape for Power BI Data - Excelerator BI