Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, hoping I can find help on here as I have tried everything I know and can't ge the thing working.
I have a date table and a financial table, they have 3 relationships from the Date to Finanace table, so;
Date > Sale Date (1 to *) - Active relationship
Date > Val Date (1 to *) - Inactive
Date > Can Date (1 to *) - Inactive
I removed all other joins to these two tables in my model so they are totally isolated.
I created a measure to do a sum of a column using the Date to Val Date relationship but instead it filters the column based on the default active relationship Date > Sale.
Any help would be appreciated
Thanks,
Ben
Solved! Go to Solution.
Try
Test measure = CALCULATE( SUM( 'Fin table'[Amount]),
USERELATIONSHIP('Date'[Date], 'Fin table'[Val date]),
TREATAS( { 2, 3}, 'Fin Table'[Type])
)
Move the USERELATIONSHIP into the initial CALCULATE, then just return sale
Already tried that and still won't work
Try
Test measure = CALCULATE( SUM( 'Fin table'[Amount]),
USERELATIONSHIP('Date'[Date], 'Fin table'[Val date]),
TREATAS( { 2, 3}, 'Fin Table'[Type])
)
Spot on! thanks for the help
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
6 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |