Forum Discussion

DayDayUp's avatar
DayDayUp
Frequent Visitor
2 years ago

Need Help DAX WITH USERELATIONSHIP

hi everyone,

I have a probelm,

This is my simple data model,

This is my measure:

 

 

Measure 1 = CALCULATE(
SUM(T3[Qty])
                 ,FILTER(T1,T1[ID]=1)
                )


Measure 2 = CALCULATE(
SUM(T3[Qty])
                 ,FILTER(T1,T1[ID]=1)
                 ,
              USERELATIONSHIP(P1[ID],T3[PersonID]))

 

 

Why measure is 10, not 30?

 

if use this measure5 as below:

 

 

 

Measure 5 = CALCULATE(
SUM(T3[Qty])
            
                 ,
              USERELATIONSHIP(P1[ID],T3[PersonID]))

 

 

or

Inactive the relationship P1-> T1,

 

the result seems work well.

 

It seems that the relationship P1-> T1  still works in Measure 2, this is not my expected output.

My expected output for Measure 2 should be 10+20=30

 

This is demo.

 

Please help

 

Need Help

2 Replies

    • DayDayUp's avatar
      DayDayUp
      Frequent Visitor
      2 years ago

      hi ThxAlot 

      Thank you for your reply, and how to get my expected output for Measure 2( 10+20=30) by dax?

       

      I don't want to change my data model, since this is a simple demo model, my actual production data model has been running for a long time, It cannot be changed arbitrarily.

       

      And did anyone else could help?

      Thanks in advance