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
Baerbel's avatar
Baerbel
Helper I
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