Forum Discussion

Promethes_2's avatar
Promethes_2
Icon for Helper II rankHelper II
9 years ago
Solved

USERRELATIONSHIP With SUM and Filter Question

Hello,   I have the following tables:   'Calendar'[Date]  1 to M -> 'Sales'[Posted Date]   My calendar table has a calculated column [Is Current Week] that holds a value of 1 if true if the dat...
Need Help
  • mattbrice's avatar
    mattbrice
    9 years ago

    How about this version.  It should work:

     

    Measure =
CALCULATE (
    SUM ( 'Sales'[Amount] ),
    USERELATIONSHIP ( 'Calendar'[Date], 'Sale'[Order Date] ),
    'Calendar'[Is Current Week] = 1
)
mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution Sage
9 years ago

How about this version.  It should work:

 

Measure =
CALCULATE (
    SUM ( 'Sales'[Amount] ),
    USERELATIONSHIP ( 'Calendar'[Date], 'Sale'[Order Date] ),
    'Calendar'[Is Current Week] = 1
)
Promethes_2's avatar
Promethes_2
Icon for Helper II rankHelper II
9 years ago

It actually all boiled down to a misconception that I had transactions in the current week when I did not.  Thank you for your reply, I marked your answer as the solution as it does work.  I

  • mattbrice's avatar
    mattbrice
    Icon for Solution Sage rankSolution Sage
    9 years ago

    Good to hear as that was my next suggestion.  I coulnd't see an issue with the measure based on facts given.