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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
DebbieE
Community Champion
Community Champion

How to set a visual to use the Inactive Relationship of another date in the date table

I have the following measure

 

Number of Records = COUNT(Metrics[RecordKey])
 
And a date table
There is an active connection to Main Date
And and Inactive Connection to Supporting Date
I want my visual to use Supporting date rather than main date
 
But I have no idea how to reference the USERELATIONSHIP when the measure above makes no mention of dates
 
Will I have to create a new mesure specifically referencing the USERELATIONSHIP that should only be used for date visuals?
 
 
1 ACCEPTED SOLUTION
DebbieE
Community Champion
Community Champion

Ive got it 

Number of Records  for date visuals= CALCULATE(COUNT(Metrics[RecordKey])

,USERELATIONSHIP(Metrics[SupportDateKey],'Date'[DateKey]
)

View solution in original post

3 REPLIES 3
DebbieE
Community Champion
Community Champion

Ive got it 

Number of Records  for date visuals= CALCULATE(COUNT(Metrics[RecordKey])

,USERELATIONSHIP(Metrics[SupportDateKey],'Date'[DateKey]
)
PaulDBrown
Community Champion
Community Champion

Sorry, why do you need to reference to the second date table? Are you going to use a date slicer or filter? 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Its fine. I figured it out above

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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