Forum Discussion

iris__bi's avatar
iris__bi
Frequent Visitor
1 year ago
Solved

USERELATIONSHIP() - Visual Filter

Hi Folks, please help out.   My date table:  Calendar = VAR start_date = MIN(hypothetical_jira_tickets[Created Date]) VAR end_date = TODAY() RETURN ADDCOLUMNS( CALENDAR(start_date, end_date)...
Need Help
  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi iris__bi ,

    Please refer attached PBIX file.

     

    If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

    Thank you

johnt75's avatar
johnt75
Icon for Super User rankSuper User
1 year ago

One approach would be to make both relationships inactive and use USERELATIONSHIP in both measures. That would prevent the line chart from filtering to just those rows with a created date in the selected month.

You could then create a measure like

Row is visible =
VAR ChosenDates =
    VALUES ( 'Calendar'[Date] )
VAR Result =
    IF (
        SELECTEDVALUE ( hypothetical_jira_tickets[Closed Date] )
            IN ChosenDates
                || SELECTEDVALUE ( hypothetical_jira_tickets[Created Date] ) IN ChosenDates,
        1
    )
RETURN
    Result

and apply that as a filter to the table visual, set to show only when the value is 1.