Forum Discussion

Mamoun_issa's avatar
Mamoun_issa
Frequent Visitor
6 years ago

Tables with Two Key

Hello,   I Have two tables the first includes the Revenue Details and the other one claims, the tables looks something similar to the below,   Medical Record No Visit Number Visit Date Name...
DAX
key
Merge
query
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Mamoun_issa 

i don't understand. it works perfect on your data sample

please, extend your mention, what do you mean "first expression"?

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

Mamoun_issa's avatar
Mamoun_issa
Frequent Visitor
6 years ago

az38 The Formula i made was like this :

 

Formula = CALCULATE(SUM(ERAClaim[Activity.PaymentAmount]),
FILTER(ALL(ERAClaim),
ERAClaim[ID]=SELECTEDVALUE(ACR[PHA_CLAIM_ID]) || ERAClaim[ID]=SELECTEDVALUE(ACR[CLAIM_ID])
))
 
However, the result i got are as follow, it takes only the sum of the first claim id