Forum Discussion
How to write this Logic in DAX
(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])
HI Anonymous,
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
3 Replies
- tackytechtom
Most Valuable Professional
Hi Anonymous ,
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/ HI Anonymous,
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
