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 Adamk,

thanks a lot for taking time to try to help me. 
As I'm not alloud to share the original structure I tried to modify it. You can see the structure and the connections of the tables. Except the Calendar_table, the other DIM-tables are for other calculations in other visuals and not relevant for my calculation.

I'm trying to calculate the sum(value) from table1 for a certain perion of time (Months, yréar) and differentiated by C_Group and C_type (C_type is a part of the C_Group [hierarchy].

Table 2 consist of colums silimiar like this

PR_IDDC:IDMC_IDExplanation
1123888as the project is carried out as su-contractor, the direct customer (DC) differs from the main customer (MC)
2432432project carried out as main contractor, so DC and MC are the same

 

Table 3 consists of 5 colums - similiar like this:

DC_IDMC_IDC_NameC_GroupC_Type
123789Foxpublicenergy
234999Fishprivateservices
432888Birdprivateenergy

 

I hope I could explain it a bit better. Thanks a lot in advance

 

Bärbel