Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Slicer on a different relationship

I currently have a dashboard with multiple pages. Page 1 and 2 uses a relationship between the calender table - date column and accounts table - start date column. For page 3 I need to use a slicer ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Sorry, found another solution. Edited the data in query manager. 

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

Anonymous USERELATIONSHIP is the way to go, what have you tried, what is your DAX expression and what is not working? Can you provide more details?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    This is a measure Im using but you can't add this one to a slicer. I've tried to use the end date kolom in the slicer but it then shows all the dates of the column. Not general years and months. 

     

    Measure example = CALCULATE(AVERAGE(ACCOUNTS[ID]),'Calendar'[ISO Year]=TODAY(),USERELATIONSHIP('Calendar'[Date],ACCOUNTS[END DATE]))