Forum Discussion

Ben81's avatar
Ben81
Icon for Helper I rankHelper I
4 years ago
Solved

Userrelationship- not working

Hi, hoping I can find help on here as I have tried everything I know and can't ge the thing working.  I have a date table and a financial table, they have 3 relationships from the Date to Finanace...
  • johnt75's avatar
    johnt75
    4 years ago

    Try

    Test measure = CALCULATE( SUM( 'Fin table'[Amount]), 
USERELATIONSHIP('Date'[Date], 'Fin table'[Val date]),
TREATAS( { 2, 3}, 'Fin Table'[Type])
)
johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Move the USERELATIONSHIP into the initial CALCULATE, then just return sale

  • Ben81's avatar
    Ben81
    Icon for Helper I rankHelper I
    4 years ago

    Already tried that and still won't work 

    • johnt75's avatar
      johnt75
      Icon for Super User rankSuper User
      4 years ago

      Try

      Test measure = CALCULATE( SUM( 'Fin table'[Amount]), 
USERELATIONSHIP('Date'[Date], 'Fin table'[Val date]),
TREATAS( { 2, 3}, 'Fin Table'[Type])
)
      • Ben81's avatar
        Ben81
        Icon for Helper I rankHelper I
        4 years ago

        Spot on! thanks for the help