Forum Discussion

HarsimranPWRBI's avatar
HarsimranPWRBI
Helper I
7 years ago
Solved

Problem with USERELATIONSHIP

I'm trying to create a measure to get Sales Amount w.r.t Delivered Date where CalenderYear is 2007 but having trouble with same.   For Sales Amount w.r.t Delivered Date works well  and show amount ...
Help
  • avanderschilden's avatar
    avanderschilden
    7 years ago

    Hello,

     

    Try this (with the correct table and column names from your model) ;

    Delivered Amount 2007 =
    CALCULATE(
    SUM(Sales[Amount]),
    USERELATIONSHIP('Date'[Date],Sales[DeliveryDate]),
    YEAR(Sales[DeliveryDate])=2007
    )
     
    Let me know!
     
    Regards,
     
    Adrian
avanderschilden's avatar
avanderschilden
Resolver I
7 years ago

Hello,

 

Try this (with the correct table and column names from your model) ;

Delivered Amount 2007 =
CALCULATE(
SUM(Sales[Amount]),
USERELATIONSHIP('Date'[Date],Sales[DeliveryDate]),
YEAR(Sales[DeliveryDate])=2007
)
 
Let me know!
 
Regards,
 
Adrian
  • HarsimranPWRBI's avatar
    HarsimranPWRBI
    Helper I
    7 years ago

    Hi Adrian,

     

    Its showing below error (USERRELATIONSHIP function can only use the two columns references participating in relationship), while using your concept. I've replaced SUM(Sales[Amount]) with measure already build.

    Which is using an  below code as an expression 

    SUMX(Sales,Sales[Quantity]*Sales[Unit Price])

     

    • avanderschilden's avatar
      avanderschilden
      Resolver I
      7 years ago
      Great! So it is solved right?
      • HarsimranPWRBI's avatar
        HarsimranPWRBI
        Helper I
        7 years ago

        Yeah it worked, and last error was due to wrong column used for relationship.

         

        The only thing is ,its only showing for CY2007 and not repeating for all CY.