Forum Discussion

AkoFar's avatar
AkoFar
Frequent Visitor
4 years ago
Solved

Adding a Slicer by USERELATIONSHIP

Hello All,   I need to use a coulmn as a slicer from another table with inactive relashionship. I created a coulmn with the following DAX code :    Program Academic Year  = CALCULATE (     VAL...
  • amitchandak's avatar
    amitchandak
    4 years ago

    AkoFar ,It should return one value

    example

    Program Academic Year =
    CALCULATE (
    Max ( 'Date Calendar'[Academic Period] ),
    USERELATIONSHIP ( 'Program Hierarchy'[Program Offering Start Date], 'Date Calendar'[Calendar Date] ),
    FILTER (
    'Date Calendar',
    'Program Hierarchy'[Program Offering Start Date] = 'Date Calendar'[Calendar Date]
    )
    )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

AkoFar ,It should return one value

example

Program Academic Year =
CALCULATE (
Max ( 'Date Calendar'[Academic Period] ),
USERELATIONSHIP ( 'Program Hierarchy'[Program Offering Start Date], 'Date Calendar'[Calendar Date] ),
FILTER (
'Date Calendar',
'Program Hierarchy'[Program Offering Start Date] = 'Date Calendar'[Calendar Date]
)
)