Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply

Date Parameter Based on Fields Not Working with USERELATIONSHIP

I am at a dead-end trying to figure out why my date table, on it's own, works just fine with all my measures, but will not work with my Parameter ( New parameters > fields > then the date fields I custom created are chosen)
Meausre Example:

 

 

Open Order = 
    CALCULATE(
        SUM('Order Summary'[Open Order Ind]),
        USERELATIONSHIP(Dates[Date],'Order Index'[Referral Date])
    )

 

 

Calculated Column Example:

 

 

Yesterday = IF(Dates[Date] = (TODAY()-1),Dates[Date])

 

 

 

Parameter:

 

 

Date Filter = {
    ("Today", NAMEOF('Dates'[Today]), 0),
    ("This Week", NAMEOF('Dates'[CurrentWeek]), 1),
    ("This Month", NAMEOF('Dates'[CurrentMonth]), 2),
    ("This Quarter", NAMEOF('Dates'[CurrentQuarter]), 3),
    ("This Year", NAMEOF('Dates'[CurrentYear]), 4),
    ("Yesterday", NAMEOF('Dates'[Yesterday]), 5),
    ("Last Week", NAMEOF('Dates'[LastWeek]), 6),
    ("Last Quarter", NAMEOF('Dates'[LastQuarter]), 7),
    ("Last Month", NAMEOF('Dates'[LastMonth]), 8),
    ("Last Year", NAMEOF('Dates'[LastYear]), 9)
}

 

 

stevie_westside_0-1700161147925.pngstevie_westside_1-1700161276642.png

 

I don't understand how the slicer using the 'Dates'[Date] field works just fine, but the parameter based on the relationship of different dates joining back into 'Dates'[Date] doesn't work.  Does anyone know why?

I have guesses, but I'm not sure where to start...
1.  The Date Parameter should be based on a boolean calculated column and not dates.
2.  Somehow the USERELATIONSHIP function within the measure is screwing something up.

Any help would be great.  Thanks!

1 REPLY 1
TheoC
Super User
Super User

@stevie_westside I'm going to go out on a limb here and say it may be associated with the fact that you're using Calculated Columns to attempt this (by their nature, they're static).  You'd probably need to integrate USERRELATIONSHIP with a Measure (first option).  Otherwise, you could test it with a direct relationship in Model view.

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.