Forum Discussion

Baerbel's avatar
Baerbel
Helper I
2 years ago
Solved

USERRELATIONSHIP gives wrong results

Dear all,   I'm struggling again with my Dax Code (I'm a beginner). ðŸ˜–  I've the following tables: tblValue with the fields PR_ID, Value,  tblProject with the fields PR_ID, DC_ID, MC_ID  (to be ...
  • Baerbel's avatar
    Baerbel
    2 years ago

    Dear all,

     

    thanks to everybody who tried to think about the challenge - I now solved it by simply not repeating 

    CALCULATE (
        SUM ( tblValue[Value] )
        )

    in the second (userrelationship) measure, but refering here to the first measure

     

    CALCULATE (
        [Measure1],  
        USERRELATIONSHIP(tblProject[MC_ID], tblCustomer[MC_ID])
    )
     
    Now it works - even if I still don't exactely understand why 
     
    All the best
    Bärbel
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Baerbel ,

 

I am not able to reproduce this question, is it possible to provide relevant data about the data model so that I can answer it for you as soon as possible.

 

Best Regards,
Adamk Kong