Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a single Calendar table with multiple other tables related to it by date. All of the relationships are "inactive" to avoid circular references et cetera. For my measures, it's easy enough to use USERELATIONSHIP to specify which relationship to use.
However, I have a Table visual, and I want to display all of the records related (via one of the inactive relationships) between table X and my Calendar table.
How can I do this?
bump
@jlutz,
What is the result after you create measure using USERELATIONSHIP() function? Could you please share dummy data of your tables and post expected result here?
Regards,
Lydia
Hey Lydia,
Basically I have a "summary" tab with measures that successfully use USERELATIONSHIP().
However my users want to see the underlying data. So if the Summary tab says that we have 6 new customers, they want to know details for those 6 customers (name, URL, account owner, etc etc) Userelationship wouldn't work on the detail tab because there is no calculation/summation - it's detail level info.
@jlutz,
Could you please share dummy data of your tables and post expected result here?
Regards,
Lydia
Hey Lydia,
Basically I have a "summary" tab with measures that successfully use USERELATIONSHIP().
However my users want to see the underlying data. So if the Summary tab says that we have 6 new customers, they want to know details for those 6 customers (name, URL, account owner, etc etc) Userelationship wouldn't work on the detail tab because there is no calculation/summation - it's detail level info.
User | Count |
---|---|
85 | |
76 | |
73 | |
70 | |
57 |
User | Count |
---|---|
98 | |
97 | |
92 | |
78 | |
70 |