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
Mamoun_issa's avatar
Mamoun_issa
Frequent Visitor
6 years ago

az38 Thank you for your response , but unfortunatly this did not work out since in the revenue details the claim ID and Pharmacy Claim ID are in the same row, so it took only the first expression (i.e. Claim ID)

az38's avatar
az38
Community 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
    • az38's avatar
      az38
      Community Champion
      6 years ago

      Mamoun_issa 

      are you sure your PHA_CLAIM_ID and CLAIM_ID are clean and have no any spaces and other invisible symbols?

      also, please, povide as your data looks like in original data sources, separately (ERAClaim and ACR)

       

      do you create FOrmula as measure or calculated column?

      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 

        Yes Im sure the data is clean, i duplicated the table to check the details thats why it is appearing in two columns, i created a measure not a column