How to write this Logic in DAX

[GustavoVarian]

I'd like to know how to write this line bellow in DAX. I'm a beginner and I'm having a lot of problems trying to write this code in Dax to return the value I need.

(select top 1 Payor.CompanyName from Payor, PatientPayor where PatientPayor.PatientSer = pat.PatientSer and Payor.PayorSer = PatientPayor.PayorSer) as conv,

This is what I tried to do so far.

Convenio = TopN(1, VALUES(Payor[CompanyName]),PatientPayor[PatientSer]) = Filter(Patient,PatientPayor[PatientSer] = Patient[PatientSer])

[v-shex-msft · Accepted solution]

HI @GustavoVarian,

You can try to use the following measure formula if helps:

formula =
VAR currpayorSer =
    SELECTEDVALUE ( PatientPayor[PayorSer] )
VAR currPatientSer =
    SELECTEDVALUE ( PatientPayor[PatientSer] )
RETURN
    CALCULATE (
        MIN ( Payor[CompanyName] ),
        FILTER ( ALLSELECTED ( Payor ), Payor[PayorSer] = currpayorSer ),
        FILTER ( ALLSELECTED ( Patient ), Patient[PatientSer] = currPatientSer )
    )

If the above also doesn't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[GustavoVarian]

Thank you all. This one did the trick! 🙂

[tackytechtom]

Hi @GustavoVarian ,

Does it work with this?

CALCULATE ( 
     MAX ( Payor[CompanyName] ),
     PatientPayor[PatientSer] = Patient[PatientSer] && Payor[PayorSer] = PatientPayor[PayorSer]
)

Does this solve your issue? 🙂 If not feel free to share some sample data and an outcome!

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/